In VBA I set text to a cell and then add a comment. I then
add text to the comment. The result is the cell has the
comment with the text that is supposed to be. However the
cell itself now has the text that I put in the cell, not
the comment but it appends itself. Example the Cell was
set to have the text: test. but now it has:testtesttest