Hello,
I'm a beginner and am having some trouble getting a code to make a pop up box appear to work. I want to have a pop-up message if a certain selection from a drop down box is selected ( in this case Loess or silt from cell A9).
I have been trying to use the following code:
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Worksheets("Cover Sheet").Range("B9").Value = "FAIL" Then
MsgBox ("Emily's message")
End If
End Sub
but I can't seem to make it work. I have attached my spreadsheet.
Any help would be appreciated!!
Bookmarks