Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Code with formula interfering in worksheet change event | Excel Programming | |||
change SUMIF formula into a vb code | Excel Discussion (Misc queries) | |||
change formula to code function | Excel Programming | |||
change the code to be a formula | Excel Discussion (Misc queries) | |||
how change formula with this code? | Excel Programming |