Open with form ??

[n2brand]

I am making a spreadsheet to track Breast cancer donations.
I have 7 colums, Date, daily total,running total,amt. raised by a certin time, person who raised it, amt. after that time, person who raised it.
I need to enetr yesterday's info every morning.
What I would like to do is to be able to open the spreadsheet and have the form dialog box open automatically. Then in put the info from there.
Is this possible and how would I do that, or how could I insert a button in one of the cells so when I open the spreadsheet I could go to A1 and click that button and it would open the form dialog box ??

Any help is greatly appreciated !!
Thanks

 

[Andrew Poulsom]

Open your workbook, right click the Excel icon to the left of File on the menu and choose View Code. Paste this into the window on the right:

Private Sub Workbook_Open()
   Worksheets("Sheet1").Activate
   Range("A1").Select
   ActiveSheet.ShowDataForm
End Sub

Change the reference to Sheet1 if necessary. Press Alt+F11 to return to your workbook, then save and close it. When you reopen it the Data Form should appear.