Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
HOW to show in A2 the formule used in A1 ?
Hello,
I want to show in A2 the formule used in A1, but I want that if I change the formule in A1, the A2 show directly the new formule. Exemple : 1) I write in A1 : =12*1000+1000 (A1 show just the result of the formule : 13'000) 2) I want that in A2 the formule : " =12*1000+1000" appear, and that if I change the formule in A1, A2 show directly the new formule. Thanks for help and copie of answer to : |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
HOW to show in A2 the formule used in A1 ?
Public function ShowFormula(rng as Range) ShowFormula = rng(1).formula End Sub Put the above in a general module, not a sheet module. in A2 put in =ShowFormula(A1) changing the formula in A1 would require and edit, so no reason to make the formula volatile -- Regards, Tom Ogilvy Thierry Fracheboud wrote in message ... Hello, I want to show in A2 the formule used in A1, but I want that if I change the formule in A1, the A2 show directly the new formule. Exemple : 1) I write in A1 : =12*1000+1000 (A1 show just the result of the formule : 13'000) 2) I want that in A2 the formule : " =12*1000+1000" appear, and that if I change the formule in A1, A2 show directly the new formule. Thanks for help and copie of answer to : |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumif formule using headers as criteria | Excel Worksheet Functions | |||
Derive a formule for finding the average | Excel Worksheet Functions | |||
On the celd show a formule not its value, why?? | Excel Discussion (Misc queries) | |||
time formule | Excel Discussion (Misc queries) | |||
Need formule which would find cell (exmp b3) value on another worksheet! please help! | Excel Worksheet Functions |