View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Luisa[_2_] Luisa[_2_] is offline
external usenet poster
 
Posts: 2
Default Excel: VBA userform is shown but not loaded/initialized even though it was first unloaded?

Hi Tom,

Sorry, but I don't understand (being a newbie with forms) ... the code
in the terminate event is executed, i.e. the workbook is closed, the
changes are saved and Userform2 is shown ... so what do you mean by
the "terminate event is suspended"? Do the terminate event not finish
up?

Regards, Luisa

"Tom Ogilvy" wrote in message ...
The terminate event for userform2 is suspended waiting the closing of
userform1.

You should manage your userforms from a single routine, passing back
information that the routine uses to make a decision on whether to show
another userform or to quit (or do something else).

--

Regards,
Tom Ogilvy