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