How to get combo box working

[papermoon]

I'm trying to create a combo box with 4 options. For each option in the drop down menu, I want to use IF statements... but I can't get the combo box to load the 4 options! This is the code that I have so far, which I got from reading online tutorials. However, it does not work and I cannot figure out the reason why. I don't get any error message, the options on the drop down menu are just blank.

Please Login or Register  to view this content.

[royUK]

What kind of drop down box are you using?

You don't add the items using the change event

[papermoon]

What kind of drop down box are you using?

You don't add the items using the change event

I believe I am using a drop down list box. Another tutorial said to change the "List" field in the properties of the combo box, but I don't see just "List" as a field in properties, I see "ListRows", "ListStyle" and "ListWidth"


Thanks for the reply

[papermoon]

bump. anyone?

[royUK]

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

[papermoon]

Ok thanks. I figured out another way to approach this problem so its all good.