Drop Down Menu Help

  • Thread starter Thread starter mcr1
  • Start date Start date
M

mcr1

I have a drop down menu, and I was wondering if there was a way put
value in there so it would let me type a value not on the list. Fo
example, if the dropdown menu gives the user the choice of selecting A
b, c, d, or E. Maybe the user wants to type in F, G, or H or just an
unforseen value that is not available in the dropdown. Can this b
done? Thanks in Advance

Miles Ree
 
Simply leave a blank row at the bottom of your list.
You really could leave in anywhere in the list, but it's less noticeable at
the bottom.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


I have a drop down menu, and I was wondering if there was a way put a
value in there so it would let me type a value not on the list. For
example, if the dropdown menu gives the user the choice of selecting A,
b, c, d, or E. Maybe the user wants to type in F, G, or H or just any
unforseen value that is not available in the dropdown. Can this be
done? Thanks in Advance

Miles Reed
 
In the data validation dialog box, select the Error Alert tab
Remove the check mark from 'Show error alert after invalid data is entered'
 
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

Select drop down menu option using libre-calc macro 0
Linking drop down lists to another list 4
Drop Down choice needs to lead to another drop down menu 1
Drop-down Delete Multiples 1
Drop Down Menu Conditional Formatting 4
Drop Down List More 2
Double Drop-Down Validation in Excel 2007 1
Multi layered drop down 1

Back
Top