only load userform if range empty
 

what code whould i need to add to tell the userform only to load if Sheet1
cell c42 is empty.

only load userform if range empty
 

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.

only load userform if range empty
 

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.

only load userform if range empty
 

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.

only load userform if range empty
 

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.

only load userform if range empty
 

what code do i add to a commandbutton2 for the next?

they enter name and lastname in the textbox. when hitting commandbutton2 i
need that data from textbox1 in the next open cell sheet1 column c down. and
then command button disable. refresh either userform1 or listbox1

should i use unload userform1 or rather userform1.hide?


thanx nigel



"Nigel" wrote:

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.