The Excel Validation feature will do what you want: 1. Select the cell(s) you want to validate. 2. On the Data menu click Validation then click the Settings tab 3. In the Allow box select List 4. Select Range containing allowed values 5. Click OK
The attached spreadsheet illustrates the above. Note that Cell D5 has a pull-down that accepts only the allowed values. If you have any questions let me know. Tom On Wed, Nov 19, 2008 at 3:03 PM, 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 -~----------~----~----~----~------~----~------~--~---
ValCell.xls
Description: MS-Excel spreadsheet
