Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
comobox-name as variable
Depends if its a forms checkbox or a control toolbox combobox.
Former worksheets(my_sheet).DropDowns(counter).Visible=Tr ue Latter worksheets(my_sheet).Oleobjects(counter).Visible=T rue -- HTH RP (remove nothere from the email address if mailing direct) "Christian Galbavy" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
comobox | Excel Discussion (Misc queries) | |||
why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel? | Excel Worksheet Functions | |||
Run-time error '91': "Object variable or With block variable not set | Excel Programming | |||
macro & comobox | Excel Programming | |||
ComoBox Resluts | Excel Programming |