Mwssage Box based on cell input

[Shamsuddeen]

Hi,

I need to pop up a message box while entering any value in any of the cells from A10 thru A15.

Thanks in advance

 

[kpark91]

VBA code

Private Sub Worksheet_Change(ByVal Target As Range)
    If Not Intersect(Target, Range("A10:A15")) Is Nothing Then
        MsgBox "The active cell does Intersect A10:A15"
    End If

End Sub

 

[Shamsuddeen]

Hi KPark,

Exactly what I was looking for. Great!!!!

thanks

 

[Shamsuddeen]

Re: Trigger a Macro based on cell input value

Hi All,

I would like to trigger a macro based on the value entered in any cells in Range("A10:A15").

The macro "Ledger" should run if user enters any numeric value in any cells in Range(A10:A14) and macro "SubLedger" should run if user enters any numeric value in Cell A15.

If any non-numeric value is entered in any of the above cells, a message "Please enter a Numeric Value" should be displayed.

Thanks in advance