code to change formula

D

Dal

Hi,

I have a formula in my Data source worksheet which is as follows:

=IF(OR(R5<TODAY()-7,GM5<TODAY()-7,GO5<TODAY()-7),"False","True")

I need code to be able to change the number i.e.-7 to -10.

Is this possible by selecting a command button and then the user specifying
which number they want to replace the -7?

thanks
 
B

Bob Phillips

Put the variable in a cell that the user can update, and then use that in
the formula.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Top