Hi,
I'm making some improvements to a spreadsheet and would like to add 2 different pop up boxes depending on what value is calculated in D-column.
With formulas:
Without formulas:
If =>1000, but <2000, then MsgBox "3C or SAP Ops must be completed".
If >2000, then MsgBox "PSA must be started".
I only want one pop up box of the two to appear, and the >2000 pop up box is first priority.
Id also like for no pop up box to appear if the value is <1000.
Please help, I've tried VBA coding and data validation methods but nothing has worked for me thus far.
Thank you,
Reece
I'm making some improvements to a spreadsheet and would like to add 2 different pop up boxes depending on what value is calculated in D-column.
With formulas:
Without formulas:
If =>1000, but <2000, then MsgBox "3C or SAP Ops must be completed".
If >2000, then MsgBox "PSA must be started".
I only want one pop up box of the two to appear, and the >2000 pop up box is first priority.
Id also like for no pop up box to appear if the value is <1000.
Please help, I've tried VBA coding and data validation methods but nothing has worked for me thus far.
Thank you,
Reece