help looping through textboxs on userform
 

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

help looping through textboxs on userform
 

Hi,

you can add into your loop check for textbox

For Each Item In frmmanualentry.Controls
if item.name like "textbox*" then
item.value = ""
end if
next item

Regards,
Ivan

help looping through textboxs on userform
 

thanks for the suggestion i tried that but when i step through the code
and I move my mouse over the word Item on the line "FOR each ...." item
is coming up as the value of the textbox,combobox,label etc. so it does
not seem to register it and clear the value.


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

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

help looping through textboxs on userform
 

Thank Nigel.:eek:


I think I should KICK myself right now. I see where I was going wrong I
forgot although the it was a textbox the control had a name which was
textbox if the textbox.name was cat then i would have had top have
"cat" & i




thanks man


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