check column for value and show message box

[chi11]

Hi all,

I know this will be a if then macro but I don't know how to write these. Basically what I am looking for is a macro that will check column J from A2 down for a value of 75 or larger, if over or equal to 75 show message box ( i'll figure out what to say in it later), if the numbers are all under 75 show message box "done". the numbers are times in mm:ss.

Thanks in advance.

[JBeaucaire]

This macro will use an AUTOFILTER on column J to see if any values are equal/greater than your NumCheck:

Please Login or Register  to view this content.

Put the macro into a normal code module (Insert > Module), not a sheet module. Then use a button on your sheet to run it, or run it with Alt-F8.

[chi11]

sweet that works awesome, is there anyway something could be added to highlight that row??

[JBeaucaire]

It could be more than one row, yes?

[chi11]

yes it can be

[JBeaucaire]

Except for the popup message, this could actually be done in column F using nothing more than Conditional Formatting. Then a quick glance down the column and you would see the highlighted cells.

Anyway....

Please Login or Register  to view this content.

[chi11]

works awesome, REP ++