VBA macro message box

[Ash34]

Hi
Can anyone help me with a macro for a message box when specific text from a drop down list is entered into a cell. IE if ”school“ is selected from drop down list for any cell in column c, then a message box prompting “must contact teacher” pops up.
thanks

 

[mse330]

Hello & welcome to the forum

Right click the tab then view code & insert the below code

Private Sub Worksheet_Change(ByVal Target As Range)
  If Not Intersect(Target, Columns("C")) Is Nothing Then If Target.Value = "school" Then MsgBox "must contact teacher", vbExclamation
End Sub

 

[Ash34]

Hello
That works perfectly! Thanks a million

 

[mse330]

Glad to help & thanks for your feedback