Here's what I'm trying to accomplish.
When macro runs, search column D:J on the GrossNet sheet, and if a value greater than 50 or less than -50, display a prompt "Value greater / less than 50 present, do you want to proceed?". If yes, continue macro, if no, end macro.
I have some code below, but I am not certain on how exactly to integrate. Any assistance would be appreciated!
I think this formula works for the data validation, unless there's a better method for accomplishing this?
I have the following code for the actual message box, which I know is pretty basic.
When macro runs, search column D:J on the GrossNet sheet, and if a value greater than 50 or less than -50, display a prompt "Value greater / less than 50 present, do you want to proceed?". If yes, continue macro, if no, end macro.
I have some code below, but I am not certain on how exactly to integrate. Any assistance would be appreciated!
I think this formula works for the data validation, unless there's a better method for accomplishing this?
Code:
=IF(OR(MAX(D:J)>50,MIN(D:J)<-50),1,0)I have the following code for the actual message box, which I know is pretty basic.
Code:
If MsgBox("Value greater / less than 50 present, do you want to proceed?", vbYesNo) = vbNo Then Exit Sub
