Hi Laf,

However, if the user increases it
and then goes back to the cell to try to make it lower than the
default, then it sets it back to the default, not the higher value they
had there previously. For example, if the default is 4% and then I
increase it to 5% and then try to lower it to 3%, it will set it back
to the 4% instead of 5%. Is there a way to set it back to what it
previously had in there instead of setting it to the default.

One way is to use the Selection_Change event to store the original number
in a module-level variable and set the cell back to that (assuming it is
above the threshold level).

Regards

Stephen Bullen
Microsoft MVP - Excel

Professional Excel Development
The most advanced Excel VBA book available
www.oaltd.co.uk/ProExcelDev