Validation query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to have a validation drop down list which includes a blank
entry that you can enter something different in - for example, I have a list
of Journalist names for people to choose from in my list but occasionally
there might be a random extra person that needs to be entered seperately...?
 
When setting up the Data Validation....

Set the Error Alert, on tab 3, to "Warning".
(Warnings allow the non-list item to be accepted)

Then enter a message telling the user that the new item is not on the list.

Does that help?
***********
Regards,
Ron

XL2002, WinXP
 
Excellent - exactly what I wanted! thanks.

Ron Coderre said:
When setting up the Data Validation....

Set the Error Alert, on tab 3, to "Warning".
(Warnings allow the non-list item to be accepted)

Then enter a message telling the user that the new item is not on the list.

Does that help?
***********
Regards,
Ron

XL2002, WinXP
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using Data Validation via an array to stop manual entries - possib 4
How do I get drop-down list that includes, eg top10 1
Data Validation drop-down width, with named range source (XL03 and 4
Data Validation 1
Checkboxes within a list 5
drop down list 3
Data Validation 3
Data Validation List Names 2

Back
Top