Combo Box Question
 

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

Combo Box Question
 

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
.

Combo Box Question
 

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
.

Combo Box Question
 

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
.