View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
bpeltzer
 
Posts: n/a
Default data entry with drop down lists

Two steps that may help; both are changes in the Data Validation setup...
First, on the Error Alert tab, clear the checkbox labeled 'Show error...'
Second, create a prompt using the Input Message tab. Select the 'Show input
message' checkbox, and enter the prompt in the 'Input Message' textbox,
something like Choose from the list provided or type your own value.
Now when the input cell is selected, they'll get the prompt, and the
drop-down making it easy to select one of the pre-defined values.
HTH. --Bruce

"Cyrus" wrote:

I would like to creat a drop down list where user can select specified text,
however, I would also like the user to type other entries. I don't
necessarily want to completly restirct data imput, but I want to make easier
for user.


I've created an error message that explains to the user how to add their
entry to the list, but I'd like to make easier where they can either select
from drop down list or enter their own entry.

Thanks

Cyrus