+ Reply to Thread
Results 1 to 6 of 6

How to shorten my msgbox code or show on mutiple lines?

  1. #1
    Forum Contributor
    Join Date
    12-20-2011
    Location
    United States, Ohio
    MS-Off Ver
    Excel 2010
    Posts
    295

    Question How to shorten my msgbox code or show on mutiple lines?

    Any recommendations on how to shorten my code, OR AT LEAST How to write it on mutiple lines so that I can see it all without having to scroll on screen?

    Can I somehow use the "_" (underscore) that I have seen been used before?

    Please Login or Register  to view this content.
    Last edited by clemsoncooz; 02-08-2012 at 09:32 AM.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,614

    Re: How to shorten my msgbox code or show on mutiple lines?

    Put the underscores where you want ... you need a space before it:

    Please Login or Register  to view this content.

    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Expert tigeravatar's Avatar
    Join Date
    03-25-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2003 - 2013
    Posts
    5,361

    Re: How to shorten my msgbox code or show on mutiple lines?

    Please Login or Register  to view this content.


    EDIT: Beat to it by TMS
    Last edited by tigeravatar; 02-07-2012 at 05:12 PM.
    Hope that helps,
    ~tigeravatar

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  4. #4
    Forum Contributor
    Join Date
    12-20-2011
    Location
    United States, Ohio
    MS-Off Ver
    Excel 2010
    Posts
    295

    Re: How to shorten my msgbox code or show on mutiple lines?

    ok thanks - so I guess though that you are not able to place the underscore within any text that is enclosed by " " ??

    Example:
    Please Login or Register  to view this content.

  5. #5
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,614

    Re: How to shorten my msgbox code or show on mutiple lines?

    You'd have to split the text but there's no reason why not:

    Please Login or Register  to view this content.

    Regards, TMS

  6. #6
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,614

    Re: How to shorten my msgbox code or show on mutiple lines?

    Thanks for the rep.


    If you are satisfied with the solution(s) provided, please mark your thread as Solved.

    How to mark a thread Solved
    Go to the first post
    Click edit
    Click Go Advanced
    Just below the word Title you will see a dropdown with the word No prefix.
    Change to Solved
    Click Save

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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