Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Initializing a Form with multiple forms embedded
I am having trouble initializing forms embedded in a single userform.
Specifically, UserForm12 has a MultiPage Form embedded in it. The code to execute initialization is Private Sub UserForm12_Initialize() Do I need to have a seperate execution for each page in the embedded MultiPage form. This is what I tried but it did not work Private Sub UserForm12.MultiPage1.Page1_Initialize() Any suggestions?? Thanks. --- Message posted from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Initializing a Form with multiple forms embedded
There is only one initialize event and it is named
Private Sub UserForm_Initialize() regardless of the name of the userform. Within that event you can refer to the controls on the userform. -- Regards, Tom Ogilvy "bforster1 " wrote in message ... I am having trouble initializing forms embedded in a single userform. Specifically, UserForm12 has a MultiPage Form embedded in it. The code to execute initialization is Private Sub UserForm12_Initialize() Do I need to have a seperate execution for each page in the embedded MultiPage form. This is what I tried but it did not work Private Sub UserForm12.MultiPage1.Page1_Initialize() Any suggestions?? Thanks. --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Initializing a Form with multiple forms embedded
Tom:
I made the change to UserForm_Initialize() but now am getting a runtim 424 error Object Required. Any suggestions how to eliminate this o atleast where in my code the error is? -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Embedded Word doc containing text form field | Excel Discussion (Misc queries) | |||
Put form fields in Word forms into an Excel spreadsheet? | Excel Discussion (Misc queries) | |||
Compile/Analyze Word Form Field data from multiple forms? | Excel Discussion (Misc queries) | |||
Initializing User Forms | Excel Programming | |||
Embedded form? | Excel Programming |