Line break in VBA message box (MsgBox)

  • Re: Line break in VBA message box (MsgBox)


    No built in list but you can create your own.
    [vba]Sub x()


    Dim strMsg As String

    strMsg = "Crude bullet list" & vbNewLine & vbnewline
    strMsg = strMsg & "• Item 1" & vbNewLine
    strMsg = strMsg & "• The dot is CHR(149)" & vbNewLine
    strMsg = strMsg & Chr(149) & " Item 3" & vbNewLine
    strMsg = strMsg & Chr(149) & " More Items" & vbNewLine
    strMsg = strMsg & Chr(149) & " In my list"

    MsgBox strMsg, vbInformation

    End Sub[/vba]

  • Re: Line break in VBA message box (MsgBox)


    I have tweaked the macro "test". i have mad many of your code statements non operable with single apostrophe in the beginning of the line.


    now you can try even between 11:00 and 11:30



    those non operable code statements can be deleted. they have been kept for you to understand.
    after you park this modified macro (removing old "est") and save the file.
    you again save this file with the code modified by me above in a separate folder and then start deleting the non operable statements and also you want to modify