Double-click macro to produce different results based on different cell ranges

**Hobsons** · 03-05-2013, 01:00 PM

Is this possible?

Todays date to appear in column A when double clicked. And a "y" to appear in column B if double clicked.

**arlu1201** · 03-05-2013, 02:43 PM

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.

**Hobsons** · 03-06-2013, 05:03 AM

Many thanks

However, how do I start the range from say A6, so that A1:A5 are unaffected?

**arlu1201** · 03-06-2013, 05:33 AM

Updated code

Please Login or Register  to view this content.

**Hobsons** · 03-06-2013, 06:36 AM

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?

**arlu1201** · 03-06-2013, 06:46 AM

Your requirements are increasing post by post

What about the "y" in column B?

**Hobsons** · 03-06-2013, 06:55 AM

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.

**arlu1201** · 03-06-2013, 07:00 AM

Updated code

Please Login or Register  to view this content.

Everything remains the same. You just had to change the y to yy.

**Hobsons** · 03-06-2013, 07:02 AM

Sorry. I meant the "y" to appear on the first double-click and convert to a "yy" on the second double click?

**arlu1201** · 03-06-2013, 07:28 AM

Updated code

Please Login or Register  to view this content.

Re: Double-click macro to produce different results based on different cell ranges