POP up msg in excel when condition is TRUClosed

Question

Hello,

I want to get a pop up message in excel when a condition is TRUE. I am bringing in live data and want to notified through pop up when the number in the cell is less than or greater than a specified number

venkat1926 · Answer

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 

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 · Answer

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 

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.

Bekah · Answer

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??

venkat1926 · Answer

I am not clear what you want. but try this 

change first line as

Private Sub Worksheet_Change(ByVal Target As Range)


and save the file and now test.

POP up msg in excel when condition is TRU

4 responses

Similar discussions

Subscribe To Our Newsletter!