calculate sheet after inputing data on a certain cell VBA

[mark692]

hi guys is this possible, i have a cell example cell A1 if i put a number there after inputting or after entering a value on A1 the sheet will calculate.

 

[AndyMb]

hi guys is this possible, i have a cell example cell A1 if i put a number there after inputting or after entering a value on A1 the sheet will calculate.

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("A1")) Is Nothing Then
   Calculate
Else
    'Do Nothing
End If
End Sub

 

[mark692]

thank you sir! this works perfect

 

[mark692]

sorry i solved it already with else if thanks