Thread
:
User Defined Function: Format Output
View Single Post
#
4
Posted to microsoft.public.excel.programming
Jerry W. Lewis
external usenet poster
Posts: 837
User Defined Function: Format Output
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.
Reply With Quote
Jerry W. Lewis
View Public Profile
Find all posts by Jerry W. Lewis