Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loading UserForm on start up.
Using VBA in Excel, how do I display the first UserForm immediate when the
workbook has opened. The UserForm prompts the user for a date and then recalculates all the values in the worksheet according to the date. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loading UserForm on start up.
Hi Kobus,
You can wite the code in the Open event of workbook to show the form Private Sub Workbook_Open() Userform1.Show End Sub Thanks Xcelion "Kobus" wrote: Using VBA in Excel, how do I display the first UserForm immediate when the workbook has opened. The UserForm prompts the user for a date and then recalculates all the values in the worksheet according to the date. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Loading UserForm on start up.
Hi Kobus,
on the thisworkbook module in VBA Editor paste: Private Sub Workbook_Open() UserForm.Show End Sub where, UserForm is the name of your user form. to unload the userform: Unload UserForm hope this helps!! "Kobus" wrote in message ... Using VBA in Excel, how do I display the first UserForm immediate when the workbook has opened. The UserForm prompts the user for a date and then recalculates all the values in the worksheet according to the date. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel loading on start up | Excel Discussion (Misc queries) | |||
Excel loading on start up | Excel Discussion (Misc queries) | |||
Start A UserForm By Entering A Cell | Excel Programming | |||
I need a UserForm to Auto Start | Excel Programming | |||
Start-up userform | Excel Programming |