Referencing Comboboxes by Name

[XCell_Student]

Hi guys,

Long time viewer, first time poster.

I have several comboboxes that I will be using on a single worksheet and I need to assign (and read) their values. Would naming the comboboxes be the best route? I am coding several subs within one module, will I be able to reference the comboboxes by their names in the separate subs?

If naming comboboxes is the best route, then I have an additional simple question - how do I reference the comboboxes by their name?

I'm working in Excel 2010 if that helps.

Thanks.

 

[Rick Rothstein]

Hi guys,

Long time viewer, first time poster.

I have several comboboxes that I will be using on a single worksheet and I need to assign (and read) their values. Would naming the comboboxes be the best route? I am coding several subs within one module, will I be able to reference the comboboxes by their names in the separate subs?

If naming comboboxes is the best route, then I have an additional simple question - how do I reference the comboboxes by their name?

I'm working in Excel 2010 if that helps.

What kind of ComboBox are you using... Form controls or ActiveX controls?

 

[XCell_Student]

Hi Rick, I'm using Form controls I think. I need a combobox that will allow a string variable to be assigned to it, so if Forms can do that then I will be sticking with them.