Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
msgbox Question
I am having a serious lapse of knowledge right now... How do I make a msgbox have multiple lines of text instead of one ongoing line. ex. msg = "Q1: ------------------------------" & _ "Q2: ------------------------------" style = vbokonly title = Test" msgbox msg, style, title When I do this, I get Q1: ----------------- Q2:---------------- and I need them on 2 lines. -- dok112 ------------------------------------------------------------------------ dok112's Profile: http://www.excelforum.com/member.php...o&userid=10581 View this thread: http://www.excelforum.com/showthread...hreadid=479281 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
msgbox Question
Use the concatenate operator '&' to include Chr(10) in your string of
text. ie MsgBox ("Hello there" & Chr(10) & "How are you") should display: Hello there How are you Chr(10) works a little like someone having pressed Return mid-sentence. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
msgbox Question
Hello Dok112, Add a Carraige Return Line Feed to the end of of line to start a new one... msg = "Q1: ------------------------------" & vbCrLf & _ "Q2: ------------------------------" style = vbokonly title = Test" This will give you 2 lines. Sincerely, Leith Ross -- Leith Ross ------------------------------------------------------------------------ Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465 View this thread: http://www.excelforum.com/showthread...hreadid=479281 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MsgBox question | Excel Programming | |||
MsgBox Question | Excel Programming | |||
MsgBox question | Excel Programming | |||
Msgbox question | Excel Programming | |||
MsgBox Question | Excel Programming |