View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default edit a dropdown list

What kind of dropdown. Data =Validation using the list option?

Can' the just edit the source data or is this just a modification to that
one cell and not a permanent change to the dropdown list.

Assuming a one time addition to the cell only, select the cell, do
Data=Validation and select the Error Alert Tab. Uncheck the checkbox
labelled:
"Show error alert after invalid data is entered. "

This will allow a selection from the Dropdown. Then the user can go to the
formula bar and add information (or double click on the cell and add
information).

--
Regards,
Tom Ogilvy



"Kristineandwill" wrote:

Some of the people here at work need to add a drop-down list to one of their
excel worksheets. They want to be able to edit the entries after it is
selected. For example - in the list is the value Premium Paid For. They
want to select that value and add more description like a month. So, the
final detail in the cell would say Premium Paid for April.

I am not sure that it can be done...I am hoping an expert user may be able
to help.