View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Robin Hammond[_2_] Robin Hammond[_2_] is offline
external usenet poster
 
Posts: 575
Default 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