Adding selections to combo box with VBA

[jcarstens]

This should be very easy, but I am not getting it to work. I have a userform with a combo box and I just want to hard code the values to it in VBA. I want the value in the combo box to be 1 - 10. Here is what I have so far.

Please Login or Register  to view this content.

For some reason I cannot get this to work. Any suggestions would be extremely helpful.

Thank You!

[D_Rennie]

hello jcarstens.
What you have should work. Cheek to see if it is actually combobox1.

though the quickes way may be.

Please Login or Register  to view this content.

Hope this helps.

[pike]

or maybe

Please Login or Register  to view this content.

D_rennie happy new avatar

[royUK]

This should be very easy, but I am not getting it to work. I have a userform with a combo box and I just want to hard code the values to it in VBA. I want the value in the combo box to be 1 - 10. Here is what I have so far.

Please Login or Register  to view this content.

For some reason I cannot get this to work. Any suggestions would be extremely helpful.

Thank You!

I can't see why your code doesn't work, unless yo have pasted it into the wrong place, perhaps a Standard module