speedracer
02-04-2007, 08:20 PM
Is there a way to use a variable in a ComboBox name or for that matter a Macro name?
In other words, I want to be able to use a variable in order to count through a series of combo boxes and perform various actions on each of them (i.e copying the values of 20 comboboxes into various cells on another sheet)
I am inclined to reference the ComboBox like this if the variable a=1 (or whatever) Cells(a,1)=ComboBox(a).value, but obviously that is not allowed. Is there a simple way to do this?
Is there a way to call a macro in a similar fashion as well?
SRM
In other words, I want to be able to use a variable in order to count through a series of combo boxes and perform various actions on each of them (i.e copying the values of 20 comboboxes into various cells on another sheet)
I am inclined to reference the ComboBox like this if the variable a=1 (or whatever) Cells(a,1)=ComboBox(a).value, but obviously that is not allowed. Is there a simple way to do this?
Is there a way to call a macro in a similar fashion as well?
SRM