Stacking data in a comment

  • Thread starter Thread starter Bobby
  • Start date Start date
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
 
Separate your strings by vblf (linefeeds).

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top