POP up msg in excel when condition is TRU
Closed
remo
-
Oct 3, 2009 at 09:55 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Nov 9, 2011 at 07:46 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Nov 9, 2011 at 07:46 PM
Related:
- Excel pop up message if cell contains certain text
- Voice message downloader - Guide
- Hunie pop free - Download - Adult games
- Viber pop up after call - Guide
- If a cell has text then return value ✓ - Excel Forum
- Text message translator - Guide
4 responses
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Oct 4, 2009 at 01:24 AM
Oct 4, 2009 at 01:24 AM
complete information is not available. is the data imported in one cell, one row or one column or a number of rows and columns . the following event code will pop up hte message wherever the data imported is less than 5. modify the codes if neesary
right click sheet tab and click view code
in the window that comes up copy paste this code
got to that sheet type some number less than five in any cell see what happens.
right click sheet tab and click view code
in the window that comes up copy paste this code
Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target = "" Then Exit Sub If Target.Value < 5 Then MsgBox "this value is less than 5" End Sub
got to that sheet type some number less than five in any cell see what happens.
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Oct 4, 2009 at 09:19 PM
Oct 4, 2009 at 09:19 PM
you have alraedy parked a code hy right clicking sheetab and clicking view code and in resuting wndow. In the same window park this code also
the earlier code fires only when you change the cell and enters a number
in the present code(Worksheet_Change) the msgbox will appear even if you update teh existing cell.
Private Sub Worksheet_Change(ByVal Target As Range) If Target = "" Then Exit Sub If Target.Value < 5 Then MsgBox "this updated value is less than 5" End Sub
the earlier code fires only when you change the cell and enters a number
in the present code(Worksheet_Change) the msgbox will appear even if you update teh existing cell.
What is you want this condition:
A pop up box to appear when a range of cells in one particular column is greater than 0.
Is there a code for this??
A pop up box to appear when a range of cells in one particular column is greater than 0.
Is there a code for this??
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Nov 9, 2011 at 07:46 PM
Nov 9, 2011 at 07:46 PM
I am not clear what you want. but try this
change first line as
and save the file and now test.
change first line as
Private Sub Worksheet_Change(ByVal Target As Range)
and save the file and now test.
Oct 4, 2009 at 09:00 AM