View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lasse Lasse is offline
external usenet poster
 
Posts: 4
Default Loop trough comboboxes

Hi,
I have 10 comboboxes (named cbx1 to cbx10) in a worksheet. When I open the
workbook, is it possible to loop through the 10 comboboxes to set some data.

In Access it's possible with code like this:

For CB = 1 To 10
Me("cbx" & CB).Visible = True
Next CB

Is it possible to do something like that in Excel VBA?

//Lasse