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

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