How do I make Excel drop-down list values editable?

M

Mann

I have successfully created a drop-down list in a excel worksheet. One of
the values in the list is 'Miscellaneous'. If a user selects this option, I
would them to be able to type in additional information in that cell. For
example, they could type in 'Miscellaneous (New funds)'. Currently when I
try this, I get error message "A user has restricted values that can be
entered into this cell".
 
P

Peo Sjoblom

Make sure you remove any error alert check marks when you apply the
validation


--


Regards,


Peo Sjoblom
 

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

Formatted cell column in drop down list 1
Edit Drop Down List 1
drop down list 3
extend the range of cells for a drop down list 8
Drop Down Lists 2
Created invoices in Excel - not working in Drive 1
Drop-down list and error message 1
Excel 2007 / right-click / pick from drop down list 1

Top