Thread: Reseting controls
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
stefantem[_12_] stefantem[_12_] is offline
external usenet poster
  
Posts: 1
Default 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

Reply With QuoteReply With Quote