Code to say "if the selected cell is within a range and is double clicked"...

**diputz42** · 12-02-2010, 09:31 PM

I'm new to VBA but have some general programming knowledge. I've searched high and low and can't find the answer to this. What I'm trying to do is if I double click any cell within the range A1:A5, another macro will run. Here's what I have:

HTML Code:

Thanks in advance for any help!

**unley** · 12-02-2010, 09:53 PM

Giday diputz42, I'm a VBA beginner myself but I do know that you gotta put this code in the sheet you want to double click on.
The rest is up to you

Cheers

Please Login or Register  to view this content.

You may put in your code after Else

**diputz42** · 12-02-2010, 10:16 PM

Thank you so much for your reply. I actually forgot to post the double click trigger I had. But I've figured it out after having seen your Intersect and Exit Sub functions. Here's what I have now. It's working like a champ! If anyone has a more efficient way of doing this, I am open to suggestions.

HTML Code: