Mouse Click Event in VBA

How can i use this code to count clicks in different cells?

Public xRgS, xRgD As Range
Public xNum As Long
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
On Error Resume Next
If Target.Cells.Count > 1 Then Exit Sub
Set xRgS = Range("C6")
If xRgS Is Nothing Then Exit Sub
Set xRgD = Range("N5")
If xRgD Is Nothing Then Exit Sub
If Intersect(xRgS, Target) Is Nothing Then Exit Sub
xNum = xNum + 1
xRgD.Value = xNum
End Sub

this only counts clicks in cell C6, If i copy to another cell it counts the clicks in the new cell AND the first 2, i want it to count individual clicks if thats possible

How can i use this code to count clicks in different cells?

Public xRgS, xRgD As Range
Public xNum As Long
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
On Error Resume Next
If Target.Cells.Count > 1 Then Exit Sub
Set xRgS = Range("C6")
If xRgS Is Nothing Then Exit Sub
Set xRgD = Range("N5")
If xRgD Is Nothing Then Exit Sub
If Intersect(xRgS, Target) Is Nothing Then Exit Sub
xNum = xNum + 1
xRgD.Value = xNum
End Sub

this only counts clicks in cell C6, If i copy to another cell it counts the clicks in the new cell AND the first 2, i want it to count individual clicks if thats possible

@6StringJazzer,
Try using the: Worksheet_BeforeDoubleClick event.
----------------------------
Michael (Micky) Avidan
“Microsoft® Answers" - Wiki author & Forums Moderator
“Microsoft®” Excel MVP – Excel (2009-2018)
ISRAEL

@6StringJazzer,
Try using the: Worksheet_BeforeDoubleClick event.
----------------------------
Michael (Micky) Avidan
“Microsoft® Answers" - Wiki author & Forums Moderator
“Microsoft®” Excel MVP – Excel (2009-2018)
ISRAEL

Unfortunately this is a poor man's mouse click. A right click will also fire SelectionChange, which may not be desired.

@Sumit
Looks like your date is entered as a string using a single quote at the front (ie 'dd-mmm-yy instead of dd-mmm-yy). Remove the single quote from the cell content and make sure cell is formatted as a date value. Should work then.
Cheers

Very helpful. Experimenting with it. Trying to accomplish something similar.

Need to select a random cell, for example
A8,A8,& A8, copy there contents to G7, H7, & I7, then delete Row 8.

The kicker is I need this to happen on any cell I click.

I need to be able to click say

A21:C21 and have the contents moved to G20:I20 then row 21 deleted. This should happen on any cell I select.

This is very helpful however I would like to include two outcomes. If I include another Range("B6").Value = 11
in the statement as below, it doesn't matter which cell I click on, the second statement will happen (ie B6=11).
How can I correct this please? Thanks for your help.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = Range("B5").Address Then _
Range("B5").Value = 10
Range ("B6").Value = 11
End Sub

I want to semi-automate changing the data label on a point on an imbedded chart to "est." (estimated). I recorded a macro for doing this, but can't figure out how to trap the mouse click event to select the data point. Any previous tips on this?

@Jeff Kanoza,
The merged area's address is, always, the address of the most upper-left cell.
--------------------------
Michael (Micky) Avidan
“Microsoft® Answers" - Wiki author & Forums Moderator
“Microsoft®” MVP – Excel (2009-2016)
ISRAEL

I merged 9 cells together, and want to catch the mouse click in the merged area. The above code works fine for a single cell, but doesn't work once I merge them. Any help?

Thanks,
Jeff

This works:
[code snippet]
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Target = Format(Date, "dd-mmm-yy")
End Sub
[code snippet]

Hi All,

I am facing problem regarding text format to date, in my existing report date is coming ('03-Nov-14) but i want its should be (03-Nov-14).
Please help what is the vba code for above changes?

thanks and Reards
Sumit