Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
edit a dropdown list
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
dropdown list determined by another dropdown list | Excel Discussion (Misc queries) | |||
Excell Dropdown List. Display alternate text than found in list. | Excel Discussion (Misc queries) | |||
Dropdown List - list item endings not visible if column too narrow | Excel Discussion (Misc queries) | |||
result of selecting from the dropdown list should be a dropdown list | Excel Worksheet Functions | |||
result of selecting from the dropdown list should be a dropdown list | Excel Worksheet Functions |