Hi
I have a worksheet with about 200 embeded list boxes, I need each of them to have uneque name, is there away to create a macro to re name them for me.
in column k there are 31 comboboxs and I want the name to equal "Q & value in column A & SA"
colulm a value = 1
comboboxes start on row 5 in column A
in this case the combobox name would be "q1sa"
I have a worksheet with about 200 embeded list boxes, I need each of them to have uneque name, is there away to create a macro to re name them for me.
in column k there are 31 comboboxs and I want the name to equal "Q & value in column A & SA"
colulm a value = 1
comboboxes start on row 5 in column A
in this case the combobox name would be "q1sa"