When using this code:
If Target.Address = "$c$14" Then
I got the same result that you did. But using this:
If Target.Address = "$C$14" Then
It worked fine.
"Sammie" wrote:
I am trying to run a macro called hardware when the user clicks in cell C14.
I am new to VB in Excel, but use VB in Access.
When I run the following code in debug mode, I can see that it is skipping
the instructions after "then" in the if statement even when the target
address is $C$14. What am I missing?
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = "$c$14" Then
MsgBox "Hardware"
End If
End Sub
Thanks
Sammie