ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Creating carriage returns in msg or input boxes (https://www.excelbanter.com/excel-programming/300378-creating-carriage-returns-msg-input-boxes.html)

michael

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

Greg Koppel

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




Bob Phillips[_6_]

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




Robin Hammond[_2_]

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






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