Combo Box Question

W

WStoreyII

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
 
W

WStoreyII

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
 
T

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

WStoreyII said:
I mean how can i achieve this effect through code for other purposes.
Click to expand...
besides you can not use the data validation on an external source
 
Top