Combo Box Question

[Guest]

I wish to be able to add combo box's to my spread sheets that are embedded into the cell just like the combo boxs are in the pivot table and the auto filter.

How can this be done

Thanks for any help

WStoreyII

 

[Frank Kabel]

Hi
use 'Data - Validation - List'. See:
http://www.contextures.com/xlDataVal01.html

-----Original Message-----
I wish to be able to add combo box's to my spread sheets

that are embedded into the cell just like the combo boxs
are in the pivot table and the auto filter.

 

[Guest]

I mean how can i achieve this effect through code for other purposes. besides you can not use the data validation on an external source

 

[Tom Ogilvy]

If you want them embedded in a cell, data validation is the only approach
that does that. You can certainly put forms dropdowns or control toolbox
toolbar comboboxes above the cells.

Data validation can use a defined name as a source which can reference an
external excel source.

--
Regards,
Tom Ogilvy

I mean how can i achieve this effect through code for other purposes.

besides you can not use the data validation on an external source