run macro on cell entry

[sleemo]

i want a macro to run after a number (any number) has been entered into a
cell i.e a2

 

[Sam Wilson]

In the VBE window, right click the sheet and view code. Change "(General)"
to "Worksheet" in the top left drop down box, and choose "Change" in the top
right.

Yopu should see:

Private Sub Worksheet_Change(ByVal Target As Range)

End Sub

In the main window. Between these two lines put this:

If Target.Address = "$A$2" And WorksheetFunction.IsNumber(Target.Value) =
True Then Call YourMacro()


Changing "YourMacro()" to the relevant macro.

 

[sleemo]

thanks
i just had to add end if and worked great