Excel message box

Closed
reevsey23 - Aug 14, 2010 at 03:25 PM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Aug 15, 2010 at 06:43 AM
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

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Aug 15, 2010 at 06:43 AM
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
0