Open with form ??

n2brand

New Member
Joined
May 26, 2002
Messages
41
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
 

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
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:

Code:
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.
 

Forum statistics

Threads
1,136,697
Messages
5,677,270
Members
419,683
Latest member
MrVBAConfused

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top