RE: $$Excel-Macros$$ Question re: cell comments and validated lists

2010-08-01 Thread Dave Bonallack
You're welcome Dave. > Date: Sun, 1 Aug 2010 10:24:21 -0700 > Subject: Re: $$Excel-Macros$$ Question re: cell comments and validated lists > From: simon_mc_webs...@yahoo.co.uk > To: excel-macros@googlegroups.com > > That's it exactly! Many thanks Dave, > &g

Re: $$Excel-Macros$$ Question re: cell comments and validated lists

2010-08-01 Thread Sid.
That's it exactly! Many thanks Dave, Sid. On 1 Aug, 13:32, Dave Bonallack wrote: > I forgot to say that the drop-down is in C1 > > Regards - Dave. > > > Date: Sun, 1 Aug 2010 01:36:25 -0700 > > Subject: $$Excel-Macros$$ Question re: cell comments and validated lists > > From: simon_mc_webs...@y

RE: $$Excel-Macros$$ Question re: cell comments and validated lists

2010-08-01 Thread Dave Bonallack
I forgot to say that the drop-down is in C1 Regards - Dave. > Date: Sun, 1 Aug 2010 01:36:25 -0700 > Subject: $$Excel-Macros$$ Question re: cell comments and validated lists > From: simon_mc_webs...@yahoo.co.uk > To: excel-macros@googlegroups.com > > Good Evening Gurus, > > I have a quick que

RE: $$Excel-Macros$$ Question re: cell comments and validated lists

2010-08-01 Thread Dave Bonallack
Hi, I think this can only be done with an event macro. Have a look at the attached. regards - Dave. > Date: Sun, 1 Aug 2010 01:36:25 -0700 > Subject: $$Excel-Macros$$ Question re: cell comments and validated lists > From: simon_mc_webs...@yahoo.co.uk > To: excel-macros@googlegroups.com > > G