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

Unload the form and reload it?

--
HTH

Bob Phillips

"Ramthebuffs"
wrote in message
...

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

for clearing the text inside label use

Label1.Caption = ""
Label2.Caption = ""


for textbox

textbox1.text="

--
anilsolipura
-----------------------------------------------------------------------
anilsolipuram's Profile: http://www.excelforum.com/member.php...fo&userid=1627
View this thread: http://www.excelforum.com/showthread.php?threadid=38268