Simple VBA messagebox query

[jamesfbeard123]

Hi all,

Please can you help with a simple messagebox query.

I need some vba which will basically pop up a user box if someone enters speicifc text into a specfic cell.

e.g. if a user enters "Closed" into cell A1 a messagebox will pop up saying complete but if the user populates "Open" into cell A1 the message box does not appear.

Thanks,

James

 

[Maximus Tatius]

Hi,

This will work for all cells in column A... if you want it to work only for a specific cell or a specific range of rows then it should get you started

Private Sub Worksheet_Change(ByVal Target As Range)

' target changes only in Column A
If Target.Column = 1 Then

If Target.Value = "Closed" Then

MsgBox "Complete"

End If

End If

End Sub