Excel / Combo Box

[Dick7Access]

Is there a way to have an comb box in Excel

 

[Ranman256]

yes, put the combo on the form (form control), or sheet (activeX).
set it to the range of data.

 

[Dick7Access]

yes, put the combo on the form (form control), or sheet (activeX).
set it to the range of data.

Thanks

 

[Isaac]

There are advantages and disadvantages to inserting a combo box that's either a form style or ActiveX style personally I kind of prefer the the form one, you get more event options. But the activex1 will work too .. or you can just put data validation in the cell and that will be your drop-down.

 

[harpygaggle]

There are advantages and disadvantages to inserting a combo box that's either a form style or ActiveX style personally I kind of prefer the the form one, you get more event options. But the activex1 will work too .. or you can just put data validation in the cell and that will be your drop-down.

I agree with this. More often I am using the last one.

 

[Gasman]

I just use Data Validation for a cell/column and that produces a combo ?