only load userform if range empty

  • Thread starter Thread starter pswanie
  • Start date Start date
P

pswanie

what code whould i need to add to tell the userform only to load if Sheet1
cell c42 is 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
 
jip i meant show.

btw whats the diff?

Nigel said:
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
(e-mail address removed)
Click to expand...
 
Load puts the UserForm into memory but does not show the form in the
interface, UserForm.show loads and then shows it.



--

Regards,
Nigel
(e-mail address removed)
 
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)
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
Set Userform label text if form is not loaded??? 3
VBA set thick borders around non empty cells in range 0
VBA userform Vlookup Excel 1
Code Help 2
Load Userform on Workbook_Open()?? 1
Open Userform two ways 3
Macro to check if current cell value is 1 and previous cell was 0 6

Back
Top