VBA for Automatic MSg box when a specific cell value cross limit..

[santosh226001]

Hello

We are looking a VBA or macro for my project file with following

We have a project file with 10 sheets but we want if in sheet (i.e. Master) Cell Value J21 reach 50 or more then 50 then a Msg Box or User form Display with following MSG... immediately when ever work in any sheets

"YOUR DATA LIMIT IS CROSS MAXIMUM ... PLS TAKE APPROVAL FOR MORE LIMIT"

tHANKS

sANTOSH

[Olly]

Use something like this in the module of each worksheet:

Private Sub Worksheet_Change(ByVal Target As Range)
If Worksheets("Master").Range("J21").Value > 50 Then
    MsgBox "YOUR DATA LIMIT IS CROSS MAXIMUM ... PLS TAKE APPROVAL FOR MORE LIMIT", vbExclamation + vbOKOnly, "Excel Forum"
End If
End Sub