View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kenny Kenny is offline
external usenet poster
 
Posts: 27
Default User Defined Function: Format Output

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.