User Defined Function: Format Output
So how is cell formatting applied when using the excel
finance function PMT()?
-----Original Message-----
A VBA function called from a worksheet can only return a
value, it
cannot modify the environment in any way. In particular,
it cannot
change cell formats.
Jerry
wrote:
But how is it done automatically from a user defined
excel
function?
-----Original Message-----
That is done in the cell format.
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing
direct)
"Kenny" wrote in
message
.. .
If i am using a user defined function (VBA code)
i.e.
Function TestFunc(Input Variables etc...) As Variant
'Code here
TestFunc = "Result of Code"
End Function
How is cell formatting applied similar to the way the
excel function PMT() changes format to red if output
value
is negative.
.
|