Problem with Combo Boxes

[Overkill32]

Can someone explain to me cleary how to input correctly values (or items) into a Combo Box so that i don't have to reload a macro for putting them in?

The only way that seems to be working for me is to do a With loop with the additem method each time i open the file. I try putting or execution the macro in the Workbook_open() macro but it doesn't seems to be working....

Any help possible?

 

[Datsmart]

If the Data you want listed in the ComboBox is on your worksheet, in the Objects Properties, use "ListFillRange" for the data list.
Type in Range Name, or just type in the Range like, "B1:B3"