Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opening User Forms
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opening User Forms
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! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opening User Forms
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |