Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
MsgBox Spacing of Characters
This may be my imagination, but it appears there is not a one-to-one relationship between the number of spaces that I insert between the quote marks when specifying the Msg and the appearance of the text in the MsgBox when the macro is executed. For example, I have some rather long Msg statements that I would like to appear on three lines in the MsgBox. So, I insert a guesstimated number of spaces into two sections of the Msg spec to force word wrap at those sections. It's a trial and error process. Is there a one-to-one relationship? Thanks for a response. Chuckles123 -- Chuckles123 ------------------------------------------------------------------------ Chuckles123's Profile: http://www.excelforum.com/member.php...o&userid=14948 View this thread: http://www.excelforum.com/showthread...hreadid=267483 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
MsgBox Spacing of Characters
No.
msg = "Abcd" & vbNewLine & "Efgh" & vbNewLine & "ijkl msgbox msg -- Regards, Tom Ogilvy "Chuckles123" wrote in message ... This may be my imagination, but it appears there is not a one-to-one relationship between the number of spaces that I insert between the quote marks when specifying the Msg and the appearance of the text in the MsgBox when the macro is executed. For example, I have some rather long Msg statements that I would like to appear on three lines in the MsgBox. So, I insert a guesstimated number of spaces into two sections of the Msg spec to force word wrap at those sections. It's a trial and error process. Is there a one-to-one relationship? Thanks for a response. Chuckles123 -- Chuckles123 ------------------------------------------------------------------------ Chuckles123's Profile: http://www.excelforum.com/member.php...o&userid=14948 View this thread: http://www.excelforum.com/showthread...hreadid=267483 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Line Spacing ? | Excel Discussion (Misc queries) | |||
Spacing between characters | Excel Discussion (Misc queries) | |||
In Excel find characters when multiple characters exist w/i a cel | Excel Worksheet Functions | |||
SPACING | Excel Worksheet Functions | |||
Spacing | Excel Programming |