Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Load a CSV into an empty, formatted XLS? | Excel Discussion (Misc queries) | |||
How to load a listbox in a userform? | Excel Discussion (Misc queries) | |||
Userform does not load | Excel Programming | |||
LOAD userform | Excel Programming | |||
Load a Userform | Excel Programming |