msgbox

[mhobbs]

Hey,

I want to make a message box appear once if a certain cell on my workbook reads "Other."

How should I do this.

Thanks

 

[Trevor G]

Select your sheet then use right mouse button on the sheet name and select View Code, change first drop down to Worksheet then next to Channge

add this code

Private Sub Worksheet_Change(ByVal Target As Range)
If Range("B10") = "Other" Then
MsgBox "Stop"
End If
End Sub