Stacking data in a comment

B

Bobby

How can I stack numeric data like 4.60 in a Comment.Text instead of
vectorizing it? My current output looks like this:
3.50-2.75-3.68-4.25 etc.
My current code is:
Comment.Text Text:="" & (Range("F5").Comment.Text & "-" &
Format(Range("F6"), "0.00"))
Instead I would like to output:
3.50
2.75
3.68
4.25

Thank's ahead for any suggestion
 
D

Dave Peterson

Separate your strings by vblf (linefeeds).

comment.text text:="asdf" & vblf & "qwer" & vblf & "zxcv"
 
Top