How to loop through controls on a MultiPage
"42N83W" wrote in message
...
Windows XP Pro SP
Excel 2002 SP 2
I have 17 comboboxs on Page4 of MultiPage1 on a userform. How can I loop
through them to check a property without having to put 17 checks inside my
loop?
Thanks!
-gk-
I've tried this
Dim cbx As ComboBox 'also tried Dim cbx As Control
For Each cbx In frmMain.fra02_01 'fra02_01 is a frame on MultiPage1(4)
'also tried For Each cbx In
frmMain.MultiPage1(4)
If cbx.Value = "" Then flag1 = True
Next cbx
I've tried other combinations besides the above, and I keep getting a "This
Property is not supported"
-gk-
|