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