Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do you display a VBA user form when starting excel workbook?
How do you display a VBA user form when starting excel workbook? Code works
to populate a list box based on choice in previous list box but how do you show the form so that it can be used when you start excel? I want to make it an excel form to collect data that has interdependanrt fields. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do you display a VBA user form when starting excel workbook?
1 way is to start the userform from an autoopen macro.
-- http://www.standards.com/; See Howard Kaikow's web site. "dant" wrote in message ... How do you display a VBA user form when starting excel workbook? Code works to populate a list box based on choice in previous list box but how do you show the form so that it can be used when you start excel? I want to make it an excel form to collect data that has interdependanrt fields. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do you display a VBA user form when starting excel workbook?
Open your VBE window (Alt+F11)
Ensure your Project Window is open (View - Project Explorer) Click on the 'This Workbook' for your Excel file Add code but substitute MyForm for the name of your userform. ' Opens userform at startup ' Private Sub Workbook_Open() frmMyForm.Show End Sub Regards, Mickey |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do you display a VBA user form when starting excel workbook?
Additional information:
http://www.cpearson.com/excel/events.htm Chip Pearson's overview page on events. -- Regards, Tom Ogilvy "dant" wrote in message ... How do you display a VBA user form when starting excel workbook? Code works to populate a list box based on choice in previous list box but how do you show the form so that it can be used when you start excel? I want to make it an excel form to collect data that has interdependanrt fields. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display contents of a cell in a user form text box -- Excel 2003 VBA | Excel Discussion (Misc queries) | |||
Display history in user form | Excel Programming | |||
how do i display a value in a user form as a result of a selectio. | Excel Programming | |||
User Form to display more than 1 reslut | Excel Programming | |||
Auto-starting a User Form | Excel Programming |