View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
42N83W 42N83W is offline
external usenet poster
 
Posts: 19
Default 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-