There is a bit more to it than that.

If you use Load and the form is not in memory, it will execute any code in
the Userform_Initialise event, and the form will then be in memory but not
shown..

If you use Show and the form is in memory, it will execute any code in the
Userform_Activate event, and the form will be shown.

If you use Show and the form is not in memory, it will execute any code in
the Userform_Initialise event, and then any code in the Userform_Activate
event, and the form will be shown.

The form can only be in memory if it has previously been loaded, or it was
shown and then hidden (Userform1.Hide), not unloaded.


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Nigel" wrote in message
...
Load puts the UserForm into memory but does not show the form in the
interface, UserForm.show loads and then shows it.



--

Regards,
Nigel




"pswanie" wrote in message
...
jip i meant show.

btw whats the diff?

"Nigel" wrote:

If IsEmpty(Sheets("Sheet1").Range("C42")) Then UserForm1.Show

I presume you mean Show the UserForm, but if you meant Load then use

If IsEmpty(Sheets("Sheet1").Range("C42")) Then Load UserForm1


--

Regards,
Nigel




"pswanie" wrote in message
...
what code whould i need to add to tell the userform only to load if
Sheet1
cell c42 is empty.