Drop Down Menu Help

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
 
R

RagDyer

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
 
D

Debra Dalgleish

In the data validation dialog box, select the Error Alert tab
Remove the check mark from 'Show error alert after invalid data is entered'
 
Top