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

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.

How can this be done

Thanks for any help

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

"Frank Kabel" wrote:

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.

How can this be done

Thanks for any help

WStoreyII
.

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" wrote in message
...
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

"Frank Kabel" wrote:

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.

How can this be done

Thanks for any help

WStoreyII
.