comobox-name as variable

  • Thread starter Thread starter Christian Galbavy
  • Start date Start date
C

Christian Galbavy

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
 
Depends if its a forms checkbox or a control toolbox combobox.

Former

worksheets(my_sheet).DropDowns(counter).Visible=True

Latter

worksheets(my_sheet).Oleobjects(counter).Visible=True

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

generate sub dynamically 1
Calling an Object using variables (What am I doing wrong????) 2
How to hide password? 1
Variable Naming.....? 5
naming fields 1
Type Mismatch error when trying to generically set ComboBox to aComboBox variable 7
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
Shifting cells to consolidate record rows 4

Back
Top