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

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
 
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
 
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.
 
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
 
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
 
Now, if she could just teach me to use a spellchecker I wouldn't post things
like "lnowledge"
 
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.
 
Thanks Gord! No points deducted for spelling. <g>
And just ignore Peo. What do those Swedes know about hockey anyway?
 
Back
Top