Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userform_Initialize event failing to be called
Suppose i have the following code:
sub MySub() Load frmMyForm ' actions Unload frmMyForm end Sub Further assume that this code executes without Breaking or otherwise failing to execute the last statement. How come VBA often does not raise the UserForm_Initialize event when i "Load frmMyForm"? Am I missing something? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userform_Initialize event failing to be called
The initialize event is in the workbook module use it to
load the form but do not include any further code. Sub MySub() Load frmMyForm End Sub The unLoad function is assigned to a close command button on the form. Include any code for the various textboxes etc within the form module. Double click and control to start the code for the control. These are all Private Regards Peter -----Original Message----- Suppose i have the following code: sub MySub() Load frmMyForm ' actions Unload frmMyForm end Sub Further assume that this code executes without Breaking or otherwise failing to execute the last statement. How come VBA often does not raise the UserForm_Initialize event when i "Load frmMyForm"? Am I missing something? . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userform_Initialize event failing to be called
Sub Tester5()
For i = 1 To 10 cnt = i Load frmMyForm ' actions Unload frmMyForm Next i End Sub fired every time for me. -- Regards, Tom Ogilvy "R Avery" wrote in message ... Suppose i have the following code: sub MySub() Load frmMyForm ' actions Unload frmMyForm end Sub Further assume that this code executes without Breaking or otherwise failing to execute the last statement. How come VBA often does not raise the UserForm_Initialize event when i "Load frmMyForm"? Am I missing something? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Failing IF Statement | Excel Discussion (Misc queries) | |||
COUNTA failing? | Excel Discussion (Misc queries) | |||
UserForm_Initialize | Excel Programming | |||
Save Event - Determine if called by code or user | Excel Programming | |||
UserForm_Initialize? How to update. | Excel Programming |