Combo Box

[YCJ]

Hi all

I am trying to use a combo box in excel using the control toolbox in microsoft excel. Can anyone tell me how to insert data into my combo box? I've been searching all over the net, but I've only found how to enter data into combo box in userforms. I'm not creating a userform, i'm using the combo box in my excel.

Thanks in advance,
CJ

 

[repairman615]

Hello,
Welcome to the message board!

Maybe:

Right click / Format control / Control tab...Input Range

Where Input range is your list.

 

[YCJ]

wow, okay thanks! apparently i got the wrong combo box, it should be the combo box from the Forms toolbar, instead of the Control Toolbox toolbar. Finally, using your steps, i got what i wanted. XD

Thanks,
CJ