+ Reply to Thread
Results 1 to 3 of 3

Align msgbox text and Bold & underline certain text

  1. #1
    Registered User
    Join Date
    11-27-2012
    Location
    Malaysia
    MS-Off Ver
    Excel 2003
    Posts
    66

    Align msgbox text and Bold & underline certain text

    Hi,

    I have a code which look like below

    PHP Code: 
    Sub msgbox()

     
    MsgBox("The item that you select was" _
                 vbNewLine 
    vbNewLine _
                 
    "Item Id" vbTab vbTab ": Wording A" _
                 
    "Item Name" vbTab ": " _
                  Wording B
    ................_
                  vbNewLine 
    vbNewLine _
                  
    "Are you sure on your selection?"vbYesNo vbQuestion_
                  
    "Alert on [Selection] !!!")

    End sub 
    and it produce

    PHP Code: 
    The item that you select was

    Item Id   
    Wording A
    Item Name 
    Wording B..................
    ...............
    (too long)

    continue 
    the code 
    How to modified the code so that msg box show like below (Bold and underline on certain word and alignment on Item name look nicer)

    PHP Code: 
    The item that you select was

    Item Id   
    Wording A (Need to bold and Underline)
    Item Name Wording B...........
               ........


    Continue the code 
    BR
    KC
    Last edited by alexnkc; 02-22-2013 at 11:59 AM.

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Align msgbox text and Bold & underline certain text

    Sorry, but you can't do that with a standard message box.

    If you search you might find some custom message boxes.

    I had a link to one called ktMsgBox but it's dead.

    If you don't want to use something like that you could use a userform.
    If posting code please use code tags, see here.

  3. #3
    Registered User
    Join Date
    11-27-2012
    Location
    Malaysia
    MS-Off Ver
    Excel 2003
    Posts
    66

    Re: Align msgbox text and Bold & underline certain text

    I see.. if using userform, how it can substitute msgbox with userform?

    How it work?

+ 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