unrestricting drop down lists

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a drop down list to save from so much typing and I need to be
able to also add other comments to the cell after I have chosen my item from
the drop down list, but I get a popup saying typing additional data into the
cell is restricted. Basically, I can only insert drop down items into the
cell. How can I unrestrict it?
 
In the data validation dialog box, on the Error Alert tab, remove the
check mark from 'Show error alert after invalid data is entered'
 
Have you tried using the "Input Message" tab, where you can set a comment or
instructions for each individual cell in the validation?
--
HTH,

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

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

Back
Top