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: 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



  #4   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





  #5   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



.

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 10:00 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"