Quick drop-down menu question

[shav]

Hi all,
if a cell has a drop down menu, is it possible to type a valu
into that cell if none of the selections in the menu are required. Whe
I go to type in the cell, I get an error saying that the user ha
restriced it. Cheers
Sha

 

[Guest]

Hi Shav!

Select the cell(s) in question. Goto Data>Validation.
On the Error Alert tab, uncheck Show error alert....
OK out

Biff

 

[Bob Phillips]

What is the point of having DV if you do that? A list of (some) possible
values seems of little use.

--

HTH

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

 

[Biff]

I think using a dropdown point and click serves a
tremendous use. Who wants to type when you don't have to?

Biff

 

[shav]

Thanks for that. The purpose of being able to type in the drop-down bo
is that I'm trying to create an order form and sometimes we need to ad
extra info to what we are ordering. Without being able to write in th
cell, this is not possible. Cheers
Sha