How to find/edit combo box source?

[Gdareos]

I inherited and Excel 97 spreadsheet, and cannot figure out how to
EDIT the combo box used for a drop down list. I can create a combo box
from which to select values, but can't EDIT an existing combo box and
can't find the values that are being referenced in the drop down list.
This spreadsheet has a lot of those combo boxes, and I really need to
be able to edit rather than recreate.

Any help would be greatly appreciated. All my googling does is get
explanations of how to CREATE, but I need to EDIT and document these
combo boxes.

Thanks very much,
George D

 

[Eduardo]

Hi,
Position in the cell where you need to enter the information and go to Data
Validation, it will open it telling you where the list is

 

[Shane Devenshire]

Hi,

Since there are 3 kinds of combo boxes at least, you need to try three
possibilities:

1. Data, Validation combo boxes - select the cell and choose Data,
Validation, List, Source
2. Form combo boxes - right-click the combo box and choose Format Control,
on the Control tab note the Input range
3. Control Toolbox combo boxes - choose View, Toolbars, Control Toolbar,
click the Design Mode button and then right-click the combo box and choose
Properties and look at the ListFillRange. Or with the Control Toolbar
showing and the combo box selected choose View Code.

If this helps, please click the Yes button

Cheers,
Shane Devenshire

 

[Gdareos]

Thanks! I had no clue
Will try this out!

George
- - -