OzGrid

How to display a message for each if the value is greater than the mentioned values

< Back to Search results

 Category: [Excel]  Demo Available 

How to display a message for each if the value is > the mentioned values

 

Requirement:

 

The user has 2 values for cell B8, which gives a result in cell F5. If cell B8 = 9, cell F5 must be < 720 and if cell B8 = 11, cell F5 must be <780.

The user is seeking VBA code to display a message for each if the value is > the mentioned values.

 

https://www.ozgrid.com/forum/forum/help-forums/excel-vba-macros/1201612-2-cell-values-and-1-result

 

Solution:

 

Obtained from the OzGrid Help Forum.

Solution provided by chirayuw.

 

See also: Index to Excel VBA Code and Index to Excel Freebies and Lesson 1 - Excel Fundamentals and Index to how to… providing a range of solutions and Index to new resources and reference sheets

 

See also:

How to create excel VBA code to ascertain if cell value is greater than 2 cell values, show a pop up message
How to set up a pop up message when sum of columns exceeds X
How to bring an excel userform message box above all other windows
How to bring an excel userform message box above all other windows

 

Click here to visit our Free 24/7 Excel/VBA Help Forum where there are thousands of posts you can get information from, or you can join the Forum and post your own questions.


Gallery



stars (0 Reviews)