I want to format a cell so that it has a pop-up menu selection for "Yes" and
"No".

Please give more details and we'll gladly help you.

"Go Halos" wrote:

I want to format a cell so that it has a pop-up menu selection for "Yes" and
"No".

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".

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".

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".

You can enter up to 255 characters in the delimited list.
The items will be case sensitive, so if the list has yes, no as items,
users will not be able to enter Yes or YES.
Also, you won't be able to include items that contain a comma.

MartinW wrote:
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".


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Thanks Debra,

I've just been re-reading your website. Obviously, I have
to learn to scroll down more often instead of glossing
over things things I think<g I know.

By the way I'd like to take this opportunity to say
what a tremendous resource your website is. I often
show it to work colleagues in other sections of the
department. The look of awe and revelation on their
faces is a sight I wish you could see.

Regards
Martin


"Debra Dalgleish" wrote in message
...
You can enter up to 255 characters in the delimited list.
The items will be case sensitive, so if the list has yes, no as items,
users will not be able to enter Yes or YES.
Also, you won't be able to include items that contain a comma.

MartinW wrote:
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".


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html