Ask Experts Questions for FREE Help !
Ask
    bkpsusmitaa's Avatar
    bkpsusmitaa Posts: 1, Reputation: 1
    New Member
     
    #1

    Jan 13, 2007, 09:09 PM
    VBA and Excel for office97
    I have created a form in Excel using VBEditor in Excel and want to use the form to transfer data to Excel spreadsheet. I create an Excel file. Whenever the file is opened I want the form to load automatically. Then I use the form to enter data in specified cells. When I am through posing the data, I exit the orm, and then the Excel sheet with the filled up cells stand beore me. How to do it. There is a method in Excel to autorun macro whenever the file containing the macro is loaded, but I can not use it. If you want me to be more specific I can send the form and the file as attachment to your email ID.
    AllanWalker's Avatar
    AllanWalker Posts: 3, Reputation: 1
    New Member
     
    #2

    Jan 29, 2007, 10:37 AM
    The vbe editor exposes a whole pile of excel events. Change (General) to workbook from the drop down list immediately above the code window in the VBE. The adjacent list then will show all the available events. Selecting an event will produce a code stub in the ide. Workbook Open looks promising

Not your question? Ask your question View similar questions

 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

How to get better with Excel [ 2 Answers ]

My Vietnamese staff and I use Excel all the time, but we're limited to very basic stuff. Can anyone recommend an easy and comprehensive how-to reference, either book form (which we would have to order by mail) or on-line info? Thanks. -- Chuck Searcy, Hanoi

Excel Format [ 7 Answers ]

I need someone help. Everyday I need to format data like the following 1003, 1876, 1952, 2011, 2048, 2057, 2073, 2094, 2111, 2128 This gets pasted into one cell in a spreadsheet. I would like to be able to format it so it goes into the sheet 1003 1876 1952 etc into separate cells. Is this...

Excel [ 2 Answers ]

:rolleyes: I try to use excel to print an invoice, how can I put an invoice number that will auto upadate the next time I use the file?

Excel help [ 1 Answers ]

I am using excel to record some data and I have it setup to do some math based on the info that I put into certain cells. Now what I am wondering is am I able to setup the sheet so that it will prompt me for the 4 pieces of data that I want to enter and then place those in the proper cells and then...

Question about MS Excel [ 1 Answers ]

Hi, I want to copy & transpose the content of one spreadsheet to another without cell reference changing. It seems that I just cannot use Paste Link and Transpose at the same time. What should I do? Thanks in advance, Wei


View more questions Search