Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 28
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 79
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 28
Default 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



.

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,272
Default 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



  #5   Report Post  
Posted to microsoft.public.excel.programming
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







Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Carriage returns - how to get rid of them (again) Andrewsan Excel Discussion (Misc queries) 8 March 28th 07 10:15 AM
Formula for Carriage Returns Excel Believer Excel Discussion (Misc queries) 4 December 21st 06 04:37 PM
Carriage returns in the formula bar? rubeus Excel Worksheet Functions 4 July 6th 06 06:05 PM
Delete Carriage Returns Andre Excel Discussion (Misc queries) 2 December 1st 05 09:50 PM
Carriage returns tracyt620 Excel Discussion (Misc queries) 1 July 7th 05 02:52 PM


All times are GMT +1. The time now is 04:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"