Date Doubleclick Event
Spot on... thanks!
"Bob Phillips" wrote:
You could try this.
In M1, add =TODAY()
in M2, =M1+1
Copy M1 down to M7
In you cell add data validation, DataValidation, and set allow type to
List, and in the Source use =M1:M7.
Not double-click, but the cell will have a drop-down that you can click to
expose the list.
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"PG Oriel" wrote in message
...
Hi, I currently have a date in a cell. I'd like to be able to doubleclick
it
and it let me change the date. As I'd be away from the keyboard I'd like
it
to give me a drop down list of the next 7 days to choose from.
Is this possible?
Thanks in advance!
|