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.

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.

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.


.

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.

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.

.

PMT() is not a VBA function. Not everything that Excel can do is
exposed for developer use.

Jerry

Kenny wrote:

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.

.