Start VBA macro when a cell gets value

[EDSDaniel]

hello

Is there any way to make a VBA macro start when a certain cell gets a value?

 

[MichaelRo]

Look at the Worksheet Change Event ie:

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
' Only look at single cell changes
If Target.Count > 1 Then Exit Sub

'Only look at cell changes in your defined range (ie Range A1:A10)
If Not Application.Intersect(Target, Range("A1:A10")) Is Nothing Then
    If Target = "" Then Exit Sub    'If Cell is blank, Ignore
    'If Cell has value you require - Call Macro
    If Target = 1 Then
        Call YourMacroNameHere
        Exit Sub
    Else
    End If
End If
End Sub

Worksheet Change code to be placed in the worksheet you wish to check

The macro you wish to call should be in a standard module.

 

[EDSDaniel]

Sweet, thx mate