What is the control called in the list option of validation?

[Bruce]

What is the control called in the 'list' option of validation

When I go to Data>Validation and use the 'list option it adds a drop down to my cell. It differs to a combo and listbox in that it is enbedded in the cell itself. However you cannot access any properties for this control or have the list on another wokrsheet

It I can find out what the control is I should be able to get around this in code

Bruce

 

[Dave Peterson]

If you want to use data on a different worksheet, give it a nice range name and
use that name range in your Data|validation settings.

I'm not sure what you're looking for in code, but Debra Dalgleish has a bunch of
notes at:
http://www.contextures.com/xlDataVal01.html