Reseting controls
 

How can I reset all (only) textboxes from a form?


--
stefantem
------------------------------------------------------------------------
stefantem's Profile: http://www.excelforum.com/member.php...o&userid=13594
View this thread: http://www.excelforum.com/showthread...hreadid=498226

Reseting controls
 

I found out:


Dim ctl As Control

For Each ctl In Controls
If TypeOf ctl Is MSForms.TextBox Then
ctl.Object.Text = ""
End If
Next ct

--
stefante
-----------------------------------------------------------------------
stefantem's Profile: http://www.excelforum.com/member.php...fo&userid=1359
View this thread: http://www.excelforum.com/showthread.php?threadid=49822