Use a Pop Up Message Box Instead of Conditional Formatting

[singerbatfink]

Hi I would like to see a pop up message box instead of conditional formatting in Excel if 2 conditions are met, there are:

H4 >100 and H5 =Advance

I think I have the H4 part right but cant add the second condition to reference H5.

Please Login or Register  to view this content.

Thanks

[TMS]

Try

Please Login or Register  to view this content.

[singerbatfink]

Superb, thank you. Ive changed it slightly and put my conditions in a row 4 instead of column H.

Please Login or Register  to view this content.

Can the code be amended to look at each row individually that meets those conditions? I.e down to row 700?

Thansk again.

[TMS]

You could loop through the rows with data but bear in mind that this event handler will fire for EVERY change made on the worksheet whether or not the change is of any interest.

You could restrict the event handler to monitor changes to just columns H and I and use the Target row to check specific changes.

[singerbatfink]

Thanks TMS dont suppose you could give me an example of this, my knowledge is limited. Thanks

[TMS]

OK, try this:

Please Login or Register  to view this content.

[singerbatfink]

Wonderful.. Thanks for your help with this TMS

[TMS]

You're welcome.