F
funkymonkUK
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.
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.