+ Reply to Thread
Results 1 to 5 of 5

unknow line in msgbox

  1. #1
    Registered User
    Join Date
    03-16-2009
    Location
    italy
    MS-Off Ver
    Excel 2003
    Posts
    64

    unknow line in msgbox

    hi
    this code show me ,in a message box, the last value in "avvisofinale" i'd like to know if is possible in the same message box on different line to show all the value in "avvisofinale(i)"
    (i do not know how many "avvisofinale" there are). many thanks

    Please Login or Register  to view this content.
    Attached Images Attached Images
    Last edited by ilkamalo; 05-27-2009 at 05:52 PM.

  2. #2
    Forum Contributor
    Join Date
    04-01-2009
    Location
    Irvine, CA
    MS-Off Ver
    Excel 2010
    Posts
    280

    Re: unknow line in msgbox

    You could just add a vbCR and the additional text you want to the msgbox line like so:

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    03-16-2009
    Location
    italy
    MS-Off Ver
    Excel 2003
    Posts
    64

    Re: unknow line in msgbox

    sorry i'm not english so probably i do not make myself clear, let'us say that there are 31 "avvisofinale", i' d like to see in a message box 30 line , and on each line the content of "avvisofinale"
    in my situation ,as in the attachement,
    5
    10
    15
    20
    25
    30
    35
    ...
    145

  4. #4
    Forum Contributor
    Join Date
    04-01-2009
    Location
    Irvine, CA
    MS-Off Ver
    Excel 2010
    Posts
    280

    Re: unknow line in msgbox

    If I understand you right, then I would not use avvisofinale as a Variant.
    Use it as a string and build your message box...

    Please Login or Register  to view this content.
    Then just display avvisofinale in the message box (which may be rather large with 145 lines).

  5. #5
    Registered User
    Join Date
    03-16-2009
    Location
    italy
    MS-Off Ver
    Excel 2003
    Posts
    64

    Re: unknow line in msgbox

    great , thank for your help !!

+ 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