Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to edit a drop down box in excel 2007
I'm trying to edit a list in a drop down box.
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to edit a drop down box in excel 2007
The items in your drop down list will be somewhere in the workbook you are
working in and is referenced by your drop down list, find the list in your work book and edit, keeping them in the same cells or the drop down will not work. hope this helps. -- Lewy "Shepjk" wrote: I'm trying to edit a list in a drop down box. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to edit a drop down box in excel 2007
Hi,
The answer depends on what type of drop down box you have - Excel supports at least 3 types - Data, Validation Lists, Control Toolbox combo boxes, and Forms toolbar combo boxes. Also there in a similar type for User Forms. Also the answer depends on what you mean by edit the drop down box. If you want to edit an item on the dropdown list when you open the list - you can't. If the drop down is a data validation list select the cell with the drop down and choose Data, Validation note the Source, it is what you will need to modify. You either edit the list in the Source box or move to the range referenced by the source box and edit there. Then you indicate in the source box if the range has changed. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Shepjk" wrote: I'm trying to edit a list in a drop down box. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to edit a drop down box in excel 2007
I have a list that I can't find the source for. Below is my formula and I
can't find it. =IF(ISBLANK(AG1),"",(VLOOKUP(AG:AG,List!B:D,3,0))) "Shane Devenshire" wrote: Hi, The answer depends on what type of drop down box you have - Excel supports at least 3 types - Data, Validation Lists, Control Toolbox combo boxes, and Forms toolbar combo boxes. Also there in a similar type for User Forms. Also the answer depends on what you mean by edit the drop down box. If you want to edit an item on the dropdown list when you open the list - you can't. If the drop down is a data validation list select the cell with the drop down and choose Data, Validation note the Source, it is what you will need to modify. You either edit the list in the Source box or move to the range referenced by the source box and edit there. Then you indicate in the source box if the range has changed. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Shepjk" wrote: I'm trying to edit a list in a drop down box. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I edit the content of a drop-down menu in excel? | Excel Discussion (Misc queries) | |||
Not able to edit or do anything in Excel 2007 | Excel Discussion (Misc queries) | |||
Excel 2007 won't let me edit it at all | Excel Discussion (Misc queries) | |||
How to Edit an Exisiting Drop-Down List in Excel 2003 | Excel Discussion (Misc queries) | |||
"combination drop-down edit " form activation in Excel | Excel Discussion (Misc queries) |