Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Thanks alot!
"Tom Ogilvy" wrote: go into the VBE and double click on the Thisworkbook entry for your specific project in the Project explorer. That will open the workbook moduel and you can create a Workbook_Open event by selecting workbook, then Open from the dropdowns at the top of the module. this will enter Private Sub Workbook_Open() End Sub In this procedure you can put Private Sub Workbook_Open() Userform1.Show End Sub See Chip Pearson's page on Events: http://www.cpearson.com/excel/events.htm -- Regards, Tom Ogilvy "MAWII" wrote in message ... I've created a user form and I want it to open when the workbook opens. I can't seem to get this to work. Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
User Forms | New Users to Excel | |||
user forms | Excel Discussion (Misc queries) | |||
User forms | Excel Programming | |||
VB user forms | Excel Programming | |||
User Forms | Excel Programming |