Auto Increment Combobox Number

[StevenD]

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.

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?

 

[BrianB]

you are correct about the code.
Don't know what you mean by "combobox number"