VBA - If cell in range is greater than = MsgBox

**Quint6778** · 11-29-2016, 12:53 PM

Hi all,

Im looking to add conditional formatting but with a message box notification. Ive found examples of single cell references, but would like to select a column of cells, to the last row, and simply message the user IF one is greater than 2000.

Is the only way to achieve this with a For loop? i could not figure the range of cells in an IF >2000 THEN MsgBox...

**kev_** · 11-29-2016, 01:37 PM

Try this
It checks (using CountIf) to see if any values in columnC exceed 2000 and then identifies which rows, and delivers a message with details

Please Login or Register  to view this content.

You could build your conditional formatting into the same loop

If you want the message delivered without running the macro manually, then an event macro is required instead, triggered when values in the sheet change. (Is this what you want?)