Go to Data -> Validation - > and select validation criteria as allow list...
_________________________________________________________________________________________________
"There are known knowns. These are things we know that we know. There are known
unknowns. That is to say, there are things that we know we don't know. But
there are also unknown unknowns. There are things we don't know we don't know."
________________________________
From: Vicent Giner <[EMAIL PROTECTED]>
To: MS Excel & VBA Macros <excel-macros@googlegroups.com>
Sent: Thursday, 20 November, 2008 1:33:47 AM
Subject: $$Excel-Macros$$ Drop down / combo list in a cell
Hello.
This is my first message to the group.
My message is not necessarily about MACROS. In fact, I would prefer
not to use MACROS, if that's possible.
I just want to create a cell whose content is restricted to the items
or values in a list. The list would be static, and it wouldn't be a
problem to fill the list by hand, as it is not expected to contain
much many items.
The user then could go to the cell and simply select one of the values
in the list, by means of a drop down control or similar.
Is there any standard option in Excel to do that? I tried something
called "lists", but it doesn't work as I would like.
I know this is an easy question, but I would be very grateful if you
could give me some hints or clues.
Thank you very much in advance!!
--
Vicent
Add more friends to your messenger and enjoy! Go to
http://messenger.yahoo.com/invite/
--~--~---------~--~----~------------~-------~--~----~
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/excel-macros?hl=en
Visit & Join Our Orkut Community at
http://www.orkut.com/Community.aspx?cmm=22913620
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com
To see the Daily Excel Tips, Go to:
http://exceldailytip.blogspot.com
-~----------~----~----~----~------~----~------~--~---
