Hidden Combo Box

[Matt]

I have received a worksheet that seems to have hidden
combo boxes that I would like to edit. The dropdown arrow
does not appear until you select the cell and when I right
click on the arrow, the menu that appears is for a regular
cell rather than a control. I have tried to edit the
properties in design mode, but have had no luck.
Thanks for your help,
Matt

 

[John Wilson]

Matt,

What it sounds like you're looking at is the result of Data Validation.
Take a look here for an explanation of how it works:

http://www.contextures.com/xlDataVal01.html

John

 

[matt]

Thanks, that is exactly what it was.

-----Original Message-----
Matt,

What it sounds like you're looking at is the result of Data Validation.
Take a look here for an explanation of how it works:

http://www.contextures.com/xlDataVal01.html

John


.

 

[matt]

Thanks, problem solved!

-----Original Message-----
Hi

Select the cell. Data.Validation
There you can edit it now.

The dropdown list can be created in 3 ways
1. You enter the list directly into source field, like 'First, Second,
Third'
2. You refer in source field to list in same worksheet, like '=$F$2:$F$10'
3. You refer i source field to named range (only way you can access list on
another worksheet), like '=MyList'


Arvi Laanemets





.