View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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?