Cell Comment Formatting, from VBA

[the_gunslinger]

ok, so i have some cells, which have a comment applied to each, based on specific criteria, here's the code i have so far....

Please Login or Register  to view this content.

now this works, exactly as i expected, it will produce the comment as per the code, and it will look like this

Current Value:
£ 3456.25

and when the value hits a minus figure, it switches to red text, however, it does 2 things that i'd like to alter

1. the negative values, show in red, but with no "-" symbol
2. it messes with the number formats, for example £ 1350.50 will come out formatted as "£ 1350.5" ..... i don't want to lose the trailing 0, and i'd also like to format the numerical value as £ 1,350,50 if possible.


Anyone have any idea how i can manipulate the formatting, or do i need to manipulate it whilst building the comment text ?

[the_gunslinger]

i got it, it wasn't so hard when i realised i needed to format it before putting it into the comment


changed the line building the text and adding the comment to this

Please Login or Register  to view this content.

and voila, perfect, as for the minus symbol, i was getting confused, it would not show that, because the value whilst less than the cost, would not be a negative value