Hello, Naveen. Thank you very much for the clue. It was there, but I didn't know it.
Anyway, if the cells are modified after being used as a selection to build the list, the "drop down list" in the target cell is also modified. Is there any way to "fix" the list in the target cell? Thanks. -- Vicent On Thu, Nov 20, 2008 at 06:46, Naveen <[EMAIL PROTECTED]> wrote: > Hi, > > Yes it can be done using Data validation in DATA menu-->List-select source. > > wil be helpful for u... > > *Regards* > *Naveen Kumar M N* > * Transport Supervisor*(*HP*) > 91-08-99728 10886 > Email :[EMAIL PROTECTED] > *Best Wishes-Karunaada Kuvara* > > --- On *Wed, 11/19/08, Vicent Giner <[EMAIL PROTECTED]>* wrote: > > From: Vicent Giner <[EMAIL PROTECTED]> > Subject: $$Excel-Macros$$ Drop down / combo list in a cell > To: "MS Excel & VBA Macros" <excel-macros@googlegroups.com> > Date: Wednesday, November 19, 2008, 2:03 PM > > 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 -~----------~----~----~----~------~----~------~--~---
