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

I'll second that!

Debra's site has been a great source of lnowledge for all of us using these news
groups.

Besides that.......she's a Canuck<g


Gord

On Sun, 4 Nov 2007 12:05:01 +1000, "MartinW" wrote:

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

I thought she was 'Leafs fan

<vbg


--

Regards,

Peo Sjoblom





"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
I'll second that!

Debra's site has been a great source of lnowledge for all of us using
these news
groups.

Besides that.......she's a Canuck<g


Gord

On Sun, 4 Nov 2007 12:05:01 +1000, "MartinW" wrote:

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

Now, if she could just teach me to use a spellchecker I wouldn't post things
like "lnowledge"



On Sat, 03 Nov 2007 19:42:41 -0700, Gord Dibben <gorddibbATshawDOTca wrote:

I'll second that!

Debra's site has been a great source of lnowledge for all of us using these news
groups.

Besides that.......she's a Canuck<g


Gord

On Sun, 4 Nov 2007 12:05:01 +1000, "MartinW" wrote:

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

Thanks Martin, that made my day! I'm glad to hear that you like the
site, and I'm fortunate that some very talented people have allowed me
to publish their work there.

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






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

Thanks Gord! No points deducted for spelling. <g
And just ignore Peo. What do those Swedes know about hockey anyway?

Gord Dibben wrote:
Now, if she could just teach me to use a spellchecker I wouldn't post things
like "lnowledge"



On Sat, 03 Nov 2007 19:42:41 -0700, Gord Dibben <gorddibbATshawDOTca wrote:


I'll second that!

Debra's site has been a great source of lnowledge for all of us using these news
groups.

Besides that.......she's a Canuck<g


Gord

On Sun, 4 Nov 2007 12:05:01 +1000, "MartinW" wrote:


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


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





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