editable cell in a dropdown list

S

Shane Devenshire

Hi,

If you mean can you edit the source list of say a Data Validation List, the
answer is yes. If you mean can you edit the list that is displayed in the
drop down, the answer is you can allow entries that are not on the list by
setting the Style to Information on the Error Alert tab of the Data
Validation dialog box. If you mean can you edit in the cell and have that
change added to the Source list automatically, for that you will need to
write VBA code.
 

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

Top