![]() |
Creating carriage returns in msg or input boxes
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 |
Creating carriage returns in msg or input boxes
& 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 |
Creating carriage returns in msg or input boxes
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 |
Creating carriage returns in msg or input boxes
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 |
Creating carriage returns in msg or input boxes
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 . |
All times are GMT +1. The time now is 12:26 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com