VBA code to run a VBA code when I press a cell.

[KlausW]

Hi I have a challenge, I have this VBA code to run a VBA code when I press a cell.
It doesn't really work as intended, it should be like that when I click on a cell in column J, the value from column A is displayed in cell J1. Example I press J6 and the date written in A6 should appear in J1.
Any help will be appreciated
Best Regards
Klaus W

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not Intersect(Target, Range("j2:j32")) Is Nothing Then
Range("j1").Value = Range("a2:a32").Value
End If
Call Mail
End Sub

 

[Alex Blakenburg]

It would be more common to use Target.Count = 1.
Since you are updating a value, if you also have a Worksheet_Change it will trigger that event.
If that is desirable then leave it the way it is if not then have Application.EnableEvents = False just after the IF and Application.EnableEvents = True just before the End If

 

[Joe4]

Klaus,

Didn't I already answer this for you over here yesterday?

VBA code to run a VBA code when I press a cell.

Hi I have a challenge, I have this VBA code to run a VBA code when I press a cell. It doesn't really work as intended, it should be like that when I click on a cell in column J, the value from column A is displayed in cell J1. Example I press J6 and the date written in A6 should appear in J1...

www.mrexcel.com

If you did not understand something in my explanation or had a follow-up question on it, you should have continued asking/posting there.

 

[Joe4]

I have now merged the two threads together (posts 9-12 were from the new thread).
In the future, please do not post the same question in two different threads.
As per forum rules, duplicate threads will typically be locked or deleted (rule 12 here: VBA code to run a VBA code when I press a cell.)