Hidden Combo Box
 

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

Hidden Combo Box
 

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 wrote:

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

Hidden Combo Box
 

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 wrote:

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

.

Hidden Combo Box
 

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


"Matt" wrote in message
...
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


.