Cancel form initialization

[b0unce]

Hi guys,

I have a user form which adds values from a dynamic range when initializing to control boxes. But if the dynamic range is empty, then there is an error when the user form is initialized. I want to make a prompt to make a user to add values and only then to initialize the needed form.

Is it possible somehow to cancel form initialization? I tried using Unload Me in the initialize sub, but it does not work.

Any ideas?

 

[RoryA]

I would perform a check in the Initialize event and if there are no values, then assign that to a form variable. Then in the Activate event, check the variable, display a message and exit if required, otherwise carry on.

 

[VoG]

You would need to check the range for values before loading the userform.

 

[b0unce]

rorya,

thanks! worked just fine!

VoG: I did perform error check, but it does not allow unloading the form on initialize event.