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.