How to append text to comment in Excel VBA?

Question

I have a VBA script that appends text to any cell's comment, however it removes all comment formatting.

My current code is as simple as

c.Comment.text "something to append" & " " & c.Comment.text

Is it possible to do this job, but without losing all comment's formatting.

Answer 1

As documented, the Text method has three parameters.
Use all three to keep existing text:

c.Comment.Text "something to append ", 1, False