How do I set up a cell to have a pop-up menu?

G

Go Halos

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

MartinW

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 Data>Validation>Settings 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
 
G

Gord Dibben

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
 
M

MartinW

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
 
D

Debra Dalgleish

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

MartinW

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
 
G

Gord Dibben

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
 
G

Gord Dibben

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

Debra Dalgleish

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

Debra Dalgleish

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