View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Christian Galbavy[_2_] Christian Galbavy[_2_] is offline
external usenet poster
 
Posts: 5
Default comobox-name as variable

Hy!

I have the following problem:
I have a function, which should set the visibility of a variable list of
comboboxes to false.
Let's say I have comboboxes named "1", "2" and "3".
Now I have tried the following:

For counter = 1 to 3
worksheets(my_sheet).counter.visible = False
Next

But now the program is looking for an object with the name "counter", and
not "1" to "3".
Has somebody an idea how I can manage this problem?

Thanks for any help!

Christian Galbavy