Custom Message if a number is column D is greater than Column L

[guitarsweety]

Can anyone help create a custom warning message to pop up if a number in column L is greater than the number in column D on the sheet named Data.

[pareshj]

Hi,

Add custom cell value change code, on B4 selection change compare D4 and L4 cell value and you can add message box in VBA.


Regards,
Paresh J

[BigDawg15]

guitarsweety,

Place this in the Data worksheet module (Alt + F11).

Please Login or Register  to view this content.

I believe it does what you want based on what you listed in your post L > D not as listed in your Title D > L. Code is easy change
if you want it as Title.

Regards,

BigDawg15

[guitarsweety]

I tried it but I can't get it to do anything

[BigDawg15]

guitarsweety,

Sorry. Try this in a regular module.

Please Login or Register  to view this content.

Regards,

BigDawg15

[guitarsweety]

Now that's pretty awesome, thank you. Is there a way to automatically run this?

[BigDawg15]

What do you mean by automatic?

When workbook opens or change is made?

BigDawg15

[guitarsweety]

When a change is made I think would be ideal

[BigDawg15]

Ok. Try this.

Please Login or Register  to view this content.

Delete the code in the standard module and insert the code in this post into the Data worksheet module. Go to the Raw worksheet and enter your data. When you click back on the Data worksheet the macro will be activated and it will pop up a message box showing each of the cells meeting the criteria.

The message in the message box can be changed also.

BigDawg15