Thread: only load userform if range empty
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Nigel[_2_] Nigel[_2_] is offline
external usenet poster
  
Posts: 735
Default 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.

Reply With QuoteReply With Quote