+ Reply to Thread
Results 1 to 4 of 4

Stacking data in a comment

  1. #1
    Bobby
    Guest

    Stacking data in a comment

    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


  2. #2
    Dave Peterson
    Guest

    Re: Stacking data in a comment

    Separate your strings by vblf (linefeeds).

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



    Bobby wrote:
    >
    > 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


    --

    Dave Peterson

  3. #3
    Bobby
    Guest

    Re: Stacking data in a comment

    Thank you Dave


  4. #4
    Bobby
    Guest

    Re: Stacking data in a comment

    Found my answer! The solution is:
    & vbLf &


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1