On Sat, 9 Aug 2003 17:01:26 +0900, "youngman"
wrote:

hi,sorry for not having my problem well explained ,

i dont In cell A1 enter the expression:
=(12.36+2.36)*25+36
instead
i just want toIn cell A1 enter the expression:
(12.36+2.36)*25+36(without ***=***)
(for i have to show the formula explicitly )
what should i do.

Off the top of my head the only way I can see you being able to do
that is to use a User Defined Function like this one:

Function EvaluateMyExpression(ExpressionText) As Double

EvaluateMyExpression = Evaluate("=" & ExpressionText)

End Function

Copy that function and paste it into a standard module in your
workbook.

Then in cell B1 you could have the formula

=EvaluateMyExpression(A1)

That will return 404 in B1, even though the entry in A1 is just plain
text.

"Hank Scorpio" wrote in message
.. .
On Sat, 9 Aug 2003 15:37:35 +0900, "youngman"
wrote:


Don't forget the = sign at the front.

In cell B1, put the expression:
=A1

This will return the result of the formula.

There's no need for any VBA programming to do that, it's just straight
expression entry.

I use excel everyday ,but there is a problem that puzzled me for a long
time.when I input a formula ,for example,in one cell I input
(12.36+2.36)*25+36,and I want to obtain the result of the formula in
another cell,what should I do.I always get (12.36+2.36)*25+36 itself
instead
of the result 404.maybe someone would tell me sth helpful,or would you
give
some hints in vba.I think confirmedly it is unnecessary to input the
formula
once again to get the result.though I havent solve the issue.
regards.

---------------------------------------------------------
Hank Scorpio
scorpionet who hates spam is at iprimus.com.au (You know what to do.)
* Please keep all replies in this Newsgroup. Thanks! *