That's a Neat Trick Gord!!

I've got a whole pile of ugly source range lists that
I can now get rid of.

I'll find this out by the usual method of pushing it till it breaks,
but, do you know what the limits are for that method?

Thanks
Martin


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Not necessary to use a source range for just a few items.

In the DV source dialog enter yes,no

Note the comma between.


Gord Dibben MS Excel MVP

On Sun, 4 Nov 2007 09:29:49 +1000, "MartinW" wrote:

Hi,

For a simple one put yes and no in 2 cells off to the right somewhere,
say J12 and J13.
Then click in A1
Go to DataValidationSettings Tab
From the Allow dropdown select List
In the Source box type =$J$12:$J$13
OK out and you are done.

For more advanced stuff check out Debra Dalgleish's site.
Scroll down to the Data Validation section.
http://www.contextures.com/tiptech.html

HTH
Martin


"Go Halos" <Go wrote in message
...
I want to format a cell so that it has a pop-up menu selection for "Yes"
and
"No".