Posted to microsoft.public.excel.programming

Nigel[_2_] Nigel[_2_] is offline

external usenet poster

Posts: 735

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 Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Load a CSV into an empty, formatted XLS?	Paul H[_2_]	Excel Discussion (Misc queries)	15	June 29th 09 10:11 AM
How to load a listbox in a userform?	Martin	Excel Discussion (Misc queries)	3	July 25th 07 03:16 PM
Userform does not load	Ozgur Pars[_2_]	Excel Programming	1	April 13th 07 10:35 PM
LOAD userform	JohnTheTemp	Excel Programming	2	September 9th 05 12:45 AM
Load a Userform	Nick	Excel Programming	1	September 10th 03 03:24 PM

All times are GMT +1. The time now is 10:16 PM.

About Us

"It's about Microsoft Excel"