Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi! I was wondering how we create hard returns within an
input box to control the layout in the window. Thanks for your help!! Michael |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
& Chr(13) &
"Michael" wrote in message ... Hi! I was wondering how we create hard returns within an input box to control the layout in the window. Thanks for your help!! Michael |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
vbCrLf
and you can also use Space(integer) to layout it out better. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Michael" wrote in message ... Hi! I was wondering how we create hard returns within an input box to control the layout in the window. Thanks for your help!! Michael |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Greg,
I've written so many message boxes that I do the following to save some time and effort. public const L2 = vbcrlf & vbcrlf 'in the top of a general module public const MT= "What I want on the top of message boxes" 'time saved writing this call msgbox("This is line 1" & l2 & "this is line 2" & l2 & "this is line 3", vbokonly, mt) 'rather than this call msgbox("This is line 1" & vbcrlf & vbcrlf & "this is line 2" & vbcrlf & vbcrlf & "this is line 3", vbokonly, "What I want on the top of message boxes") Robin Hammond www.enhanceddatasystems.com "Bob Phillips" wrote in message ... vbCrLf and you can also use Space(integer) to layout it out better. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Michael" wrote in message ... Hi! I was wondering how we create hard returns within an input box to control the layout in the window. Thanks for your help!! Michael |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Thank you!!!
-----Original Message----- & Chr(13) & "Michael" wrote in message ... Hi! I was wondering how we create hard returns within an input box to control the layout in the window. Thanks for your help!! Michael . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Carriage returns - how to get rid of them (again) | Excel Discussion (Misc queries) | |||
Formula for Carriage Returns | Excel Discussion (Misc queries) | |||
Carriage returns in the formula bar? | Excel Worksheet Functions | |||
Delete Carriage Returns | Excel Discussion (Misc queries) | |||
Carriage returns | Excel Discussion (Misc queries) |