Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi
How do I set up my message box to say blah, blah, blah etc., etc. rather than blah, blah, blah etc., etc. That is I want a line return between my txt rather than a really long message box. Thanks Jo |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Jo
Sub test() MsgBox "blah blah" & Chr(10) & _ "yet another blah" & Chr(10) & Chr(10) & _ "don't touch that dial" End Sub HTH. Best wishes Harald "Jo" skrev i melding ... Hi How do I set up my message box to say blah, blah, blah etc., etc. rather than blah, blah, blah etc., etc. That is I want a line return between my txt rather than a really long message box. Thanks Jo |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
One way:
MsgBox "blah, blah, blah" & vbNewLine & "etc., etc." Note: vbNewLine works for both WinXL and MacXL. In article , "Jo" wrote: Hi How do I set up my message box to say blah, blah, blah etc., etc. rather than blah, blah, blah etc., etc. That is I want a line return between my txt rather than a really long message box. Thanks Jo |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Hard return | Excel Worksheet Functions | |||
HARD RETURN IN A CELL | Excel Discussion (Misc queries) | |||
Replace ; with hard return | Excel Discussion (Misc queries) | |||
hard return | New Users to Excel | |||
Remove Hard Return | Excel Programming |