Dear Vicent,
Follow the below mentioned process according to step.
1. Select Data
2. Select Validation
3. "In Allow" select List
4. and In source give the range of required data or list which you want.....
*Unfeigned Regards
Manoj S Negi*
*"Miles & miles to go before I sleep"
¨`·.·´¨) Always
`·.¸(¨`·.·´¨) Keep
(¨`·.·´¨)¸.·´ Smiling!
`·.¸.·´
(¨`·.·´¨) (¨`·.·´¨)
`·.¸(¨`·.·´¨)¸.·´
`·.¸.·«*:·.
.·:*
*:·.
*«*:·.
.·:*
*:·.
* On Thu, Nov 20, 2008 at 1:33 AM, Vicent Giner <[EMAIL PROTECTED]> wrote:
>
> 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
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
