I have a question concering checking a value of a number entered into a cell
I have a spreadsheet where a operator enters numerical values into cells
In cell B4, they enter a decimal value
Then the operator clicks on a Button which begins a macro that performs numerical calculations
I would like to know can I write into the macro to show an input box whenevery the numerical valu
of B4 exceed a value of 120
I would like to input box to give the operator a chance stop the macro and reenter the value in cell B
OR verify the number and continue with the macro
I am already using data validation into cell b4 to already ensure a decimal is entered without a describing label
I appreciate any help that someone can give
thanks mike