How to add items in a combo box ?

[kjy1989]

I thought this a simple task but I've been doing research and i cant find any help. My problem is very simple, I have a userform that has ComboBox1 in it and i want to add items like "Column C" , "Column D". I've actually prepared my Macro in a module and i dont know how to transfer these in a ComboBox. I thought it was as simple as the .Additem method but i cant seem to make it work. Here are my codes:

Please Login or Register  to view this content.

I want the combobox to have the options "Column J", "Column K", etc. up to "Column Q" and when the user selects it from the dropdown, its corresponding macro sets the range column for the UnitCostColumn variable. How can this be done?

[kjy1989]

never mind solved it myself, hoho.

[HaHoBe]

Hi, kjy1989,

glad to hear but according to the Forum Rules you should point out how you did it (my guesses: using AddItem, a RowSource with cells with the column letters or a filled array):

If you solve a problem yourself before anyone else has responded, post your solution to complete the thread.

Ciao,
Holger

[kjy1989]

Hi HaHoBe,

I used the .Additem method. The reason why it wasnt working is because i wrote the code inside the combobox, (combobox_change) and it should be written under Userform_Initialize.

so in the userform_initialize my code went something like:

Please Login or Register  to view this content.

Thank you and I apologize if i overlooked that part of the forum rules.