Hi all
I have a macro that should run when I activate a specific cell.
However it runs when I go into ANY cell
My users will enter some data, so ideally I want it to activate when they press enter after putting in the data. I.e they enter data into B5, then C5, and so on entering D5 it should run.
Does that make sense
It should be really simple so I must be making a really obvious mistake
here is my macro
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
If Target.Address <> "$d$5" Then
MsgBox "got this far"
Application.Run "movedata"
End If
End Sub
Thanks!!
Cath
I have a macro that should run when I activate a specific cell.
However it runs when I go into ANY cell
My users will enter some data, so ideally I want it to activate when they press enter after putting in the data. I.e they enter data into B5, then C5, and so on entering D5 it should run.
Does that make sense
It should be really simple so I must be making a really obvious mistake
here is my macro
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
If Target.Address <> "$d$5" Then
MsgBox "got this far"
Application.Run "movedata"
End If
End Sub
Thanks!!
Cath
