Thread
:
only load userform if range empty
View Single Post
#
4
Posted to microsoft.public.excel.programming
Nigel[_2_]
external usenet poster
Posts: 735
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.
Reply With Quote
Nigel[_2_]
View Public Profile
Find all posts by Nigel[_2_]