Is it possible to use a variable to change a controls name in a For Loop?
I have several worksheet combo boxes that have the same root name, e.g., cbobox1, cbobox2. cbobox3, etc. I want to be able to keep the main name and change the numeric part in a for loop and also perform some function with the control.
This gives the basic idea. How do I make cbobox(x) evaluate correctly?