Excel message box
Closed
reevsey23
-
14 Aug 2010 à 15:25
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 15 Aug 2010 à 06:43
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 15 Aug 2010 à 06:43
Related:
- Excel message box
- Excel mod apk for pc - Download - Spreadsheets
- Instagram message request - Guide
- Setting up a box account - Guide
- Arrow keys not working in excel - Guide
- Vat calculation excel - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
15 Aug 2010 à 06:43
15 Aug 2010 à 06:43
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
