Drop Down boxes

[Guest]

I want to create a drop down box where if no options are used within the drop down, then you are able to type your own answer

 

[Debra Dalgleish]

You can enter any item in a cell with a data validation list, if you
remove the check mark from 'Show error alert after invalid data is
entered', on the Error Alert tab in the Data Validation dialog box.

The box is shown here:

http://www.contextures.com/xlDataVal04.html#Error

 

[Bob Phillips]

That is a combobox.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

I want to create a drop down box where if no options are used within the

drop down, then you are able to type your own answer