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



Bruce wrote:

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

When I go to DataValidation 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