Is their an easy way to clear a userform. I have spreadsheets setup for
web queries and then I have written a macro to interperet and display
the needed info. The problem is when I click the update button. If a
label had info in it, and now shouldn't have info, it doesn't clear
out. So it still shows the old info from the last refresh. I can put
something like label43 = (""), but I have a lot of labels and text
boxes etc. Is there an easy command that is just a global clear or
reset maybe? thanks.


--
Ramthebuffs
------------------------------------------------------------------------
Ramthebuffs's Profile: http://www.excelforum.com/member.php...o&userid=16429
View this thread: http://www.excelforum.com/showthread...hreadid=382682