Is this possible?
Todays date to appear in column A when double clicked. And a "y" to appear in column B if double clicked.
Is this possible?
Todays date to appear in column A when double clicked. And a "y" to appear in column B if double clicked.
Right click on the sheet where you need the code to run and select View code. Copy this code over -
Please Login or Register to view this content.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Many thanks
However, how do I start the range from say A6, so that A1:A5 are unaffected?
Updated code
Please Login or Register to view this content.
Once again many thanks.
However, is it possible to change the "y" to "yy" with another double click. And can the range be from A6 to A20?
Your requirements are increasing post by post
What about the "y" in column B?
I do apologies.
I meant the "y" in column B to be "yy". And the range for column A and B to be A6 to A20 and B6 to B20?
Many thanks for your time.
Updated code
Everything remains the same. You just had to change the y to yy.Please Login or Register to view this content.
Sorry. I meant the "y" to appear on the first double-click and convert to a "yy" on the second double click?
Updated code
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks