+ Reply to Thread
Results 1 to 3 of 3

MsgBox Text Display Problem: display text is truncated

  1. #1
    Registered User
    Join Date
    03-01-2016
    Location
    New Jersey, USA
    MS-Off Ver
    2013
    Posts
    54

    MsgBox Text Display Problem: display text is truncated

    I have a function that is passed a string. The function takes the string and copies it to the Clipboard and then displays the text in a MsgBox. The text is too long and is getting truncated.

    Here is the MsgBox instruction:

    Please Login or Register  to view this content.
    Question 1: What is the maximum string size that can be displayed by MsgBox?
    Question 2: Is there a simple solution to enable display of the entire string? (note: "simple" because I am not an expert)

    Thanks, much.
    Regards,
    Sue

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,613

    Re: MsgBox Text Display Problem: display text is truncated

    See the following example: Msgbox is limited to 1024 characters, while for instance popup from windows script host is not
    Please Login or Register  to view this content.
    Hope it is easy enough to be implemented in your code
    Best Regards,

    Kaper

  3. #3
    Registered User
    Join Date
    03-01-2016
    Location
    New Jersey, USA
    MS-Off Ver
    2013
    Posts
    54

    Re: MsgBox Text Display Problem: display text is truncated

    Kaper,
    Thanks for your response and example. Using your suggestion, I was able to display the full text. One curiosity, though. I ran with debug to double check the length of the text and it's only 998. Weird. But I just put a test in for length of 900 and if less than or equal to 900 use MsgBox else use Windows Script. Fantastic. Thanks, again.
    Sue

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Display occurrences of text and then display it on search page
    By murray83 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 01-14-2017, 05:21 AM
  2. [SOLVED] How to display option button GroupName in MsgBox or text string
    By Blackbeginnings in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-01-2013, 09:16 AM
  3. Display msgbox when specific text entered in specific range
    By Ali_Riza in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-20-2012, 08:05 AM
  4. Too much text in cell to display problem
    By pathfinder2000 in forum Excel General
    Replies: 4
    Last Post: 12-07-2010, 04:03 PM
  5. date display:gets truncated
    By webguync in forum Excel General
    Replies: 4
    Last Post: 09-30-2008, 05:03 PM
  6. MsgBox-want to display some text with information.
    By shapper in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-29-2008, 05:42 AM
  7. [SOLVED] wrap text display problem
    By jmp in forum Excel General
    Replies: 2
    Last Post: 02-10-2006, 05:25 PM

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