View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Nigel Nigel is offline
external usenet poster
 
Posts: 923
Default help looping through textboxs on userform

Dim ix As Integer
For ix = 1 To 10
Me.Controls("Textbox" & ix).Value = ""
Next

--
Cheers
Nigel



"funkymonkUK"
wrote in message
...

hi

I have a userform which has labels,comboboxes, textboxes and
commandbutton.

I have 10 textboxes which are names from textbox1 through to textbox10
is there a way to loop through these. What I want to do is when the
user clicks cancel button it will clear all the values which they have
entered in to textbox 1-10 and then hide the userform.

i tried something like this

'For Each Item In frmmanualentry.Controls '.Item
'
'Item.Value = ""

'Next Item

the problem is it does through all the comboboxes,labels and anythign
on the userform and changes them to blank values.


--
funkymonkUK
------------------------------------------------------------------------
funkymonkUK's Profile:
http://www.excelforum.com/member.php...o&userid=18135
View this thread: http://www.excelforum.com/showthread...hreadid=544219