Excel message box
Closed
reevsey23
-
Aug 14, 2010 at 03:25 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Aug 15, 2010 at 06:43 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Aug 15, 2010 at 06:43 AM
Related:
- Excel message box
- Voice message downloader - Guide
- Excel date format dd.mm.yyyy - Guide
- Excel free download - Download - Spreadsheets
- Voice message in messenger - Guide
- Send popup message to another computer on network windows 10 - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Aug 15, 2010 at 06:43 AM
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
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
