FormatCurrency Formatting

[TBOB]

I have the following code in my module, FormatCurrency(Amount). This gets me the ($400.00) format for a negative balance like I want, but I want it to be red too. Anyway to do that?

Thanks,

Tony

 

[xlbo]

what application?

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[PHV]

Use the Format function instead.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[TBOB]

Sorry,

It's in a text string in an Excel macro.

Tony

 

[xlbo]

As PHV says - use the FORMAT function eg.

I thnk you may need to format the cell rather than the value however....

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question