How to convert formula to string

[kelangdu]

Like the title, I want to write a cell with formula into a text string. For example, I got three values in three cells as follows:

A1 = 5
A2 = 3
A3 = 1

Then I got cell A4 with the formula: =A1*A2-A3
Now I want to make a function to convert the value in cell A4 to a text string like 5*3-1 (not the result A1*A2-A3 as the Range("A4").Formula would return).
Is there any possible way to do it?

Thanks a lot.

 

[smallxyz]

like the title, i want to write a cell with formula into a text string. For example, i got three values in three cells as follows:

A1 = 5
a2 = 3
a3 = 1

then i got cell a4 with the formula: =a1*a2-a3
now i want to make a function to convert the value in cell a4 to a text string like 5*3-1 (not the result a1*a2-a3 as the range("a4").formula would return).
Is there any possible way to do it?

Thanks a lot.

In A4,
type ="="&A1&"*"&A2&"-"&A3

 

[kelangdu]

Thank you smallxyz for your quick reply.
Sorry my question is not clear. I mean to do it in VBA, whenever a user choose a cell with formula, the function will convert the formula to a text string which show a formula of real values, not reference. Is this possible?

 

[arthurbr]

@small Quoting entire posts is just clutter and makes the thread difficult to read.