code to change formula
 

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

code to change formula
 

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)

"Dal" wrote in message
...
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