cancel the initialize event

jjpkraft · Apr 18th, 2002, 01:55 PM

Is there a way to cancel a userform_initialize event?

The userform is loaded, then the initialize event is run, then the userform is shown. My line of code that unloads the userform in the initialize event gives me an error (in Excel 97 anyway).

robfo0 · Apr 19th, 2002, 02:57 AM

why would you want to unload the form in the initialize event? do you mean a different form?

jjpkraft · Apr 22nd, 2002, 07:37 AM

I'm adding a graphic to the userform in the intialize event. If the file doesn't exist in the correct directory then I want to display a message and close the userform.

Tom Schreiner · Apr 22nd, 2002, 07:56 AM

Hi
You may need to do your Unload in the activate event...
Tom

[ This Message was edited by: TsTom on 2002-04-22 06:57 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 18th, 2002, 01:55 PM	#1
jjpkraft New Member Join Date: Feb 2002 Location: Kitchener, Canada Posts: 32	Is there a way to cancel a userform_initialize event? The userform is loaded, then the initialize event is run, then the userform is shown. My line of code that unloads the userform in the initialize event gives me an error (in Excel 97 anyway).

Apr 19th, 2002, 02:57 AM	#2
robfo0 Board Regular Join Date: Feb 2002 Location: Stockton, California Posts: 281	why would you want to unload the form in the initialize event? do you mean a different form?

Apr 22nd, 2002, 07:37 AM	#3
jjpkraft New Member Join Date: Feb 2002 Location: Kitchener, Canada Posts: 32	I'm adding a graphic to the userform in the intialize event. If the file doesn't exist in the correct directory then I want to display a message and close the userform.

Apr 22nd, 2002, 07:56 AM	#4
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Hi You may need to do your Unload in the activate event... Tom [ This Message was edited by: TsTom on 2002-04-22 06:57 ]