Hi,
I want to auto increment a combobox number on a worksheet.
I found the following code in a topic but it doesn't work, maybe because it wants the combobox to be on a userform.
It comes up with this error : -
"Compile error : Method or data member not found" and highlights the .Controls bit.
Any ideas?
I want to auto increment a combobox number on a worksheet.
I found the following code in a topic but it doesn't work, maybe because it wants the combobox to be on a userform.
Code:
For i = 1 To num
mycb = "ComboBox" & i
Me.Controls(mycb).additem "TEST"
Next i
It comes up with this error : -
"Compile error : Method or data member not found" and highlights the .Controls bit.
Any ideas?