Excel Macro

[hartless43]

I would like to run a Marco based on a cell value from the WorkSheet_Change.
The code would be similar to below. I know this is simple as simple can be, but I can't get it to work.

Private Sub Worksheet_Change(ByVal Target As Range)
If Range("G11") = 45 Then
(Macro name here)
End Sub

Thanks, Jerry

 

[Akuini]

Try:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address(0, 0) = "G11" Then
    If Target.Value = 45 Then
        (Macro name here)
    End If
End If
End Sub

 

[My Aswer Is This]

Here is how I would do it:
"Mom" is the name of the script you want to run
Mom is a Module script

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$G$11" Then
If Target.Value = "45" Then Call Mom
End If
End Sub

 

[hartless43]

Try:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address(0, 0) = "G11" Then
    If Target.Value = 45 Then
        (Macro name here)
    End If
End If
End Sub

Thanks for your reply. However, this did not do what I wanted.

 

[hartless43]

Try:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address(0, 0) = "G11" Then
    If Target.Value = 45 Then
        (Macro name here)
    End If
End If
End Sub

Thanks for your reply. However, this did not do what I wanted.