Excel message box

[Closed]
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Hello,

Im sure this has been answered before, but I'm having trouble finding it.

I want a message box to pop up every time a cell in a column (col f) has an input of the word "above"

thanks


1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
802
right click the sheet tab and click viewcode.
in the window that comes up copy this event code
======================
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column <> Range("F1").Column Then Exit Sub
If Target = "above" Then
MsgBox "the word above is in " & Target.Address
End If
End Sub
==================

type above in any cell in column F and hit enter key you will get the messge