There's no such thing as a stupid question, but they're the easiest to answer.
JoinTour
Login
 
Tag Cloud
access audio avg avg 8 bios blue screen boot bsod computer connection cpu crash css dell desktop dma driver drivers dvd email error excel explorer firefox firefox 3 freeze gimp graphics hard drive hardware hijackthis hjt install internet internet explorer itunes keyboard laptop macro malware monitor motherboard network networking outlook outlook 2003 outlook 2007 outlook express pio problem problems router seo server slow sound sp3 spyware trojan usb video virtumonde virus vista vundo windows windows vista windows xp winxp wireless
Software Development
Search
Search in:
 
Advanced Search
Tech Support Guy Forums > Software & Hardware > Software Development >
Solved: Carriage return character in VBA


HELLO AND WELCOME! Before you can post your question, you'll have to register -- it's completely free! Click here to join today! We highly recommend that you print a copy of our Guide for New Members. Enjoy!

 
Thread Tools
drawde's Avatar
Junior Member with 18 posts.
 
Join Date: Jul 2006
Location: England
Experience: Intermediate/Advanced
10-Aug-2006, 09:49 AM #1
Solved: Carriage return character in VBA
THis is probably a very stupid question, but I have just begun teaching myself VBA in Microsoft Office 2003.

I am trying to use the MsgBox function in Word to display a message box, however I need to make the message run over two lines of text. The help file says "If prompt consists of more than one line, you can separate the lines using a carriage return character (Chr(13)), a linefeed character (Chr(10)), or a carriage return - linefeed character combination (Chr(13) & Chr(10)) between each line.

This means nothing to me - I have experimented with typing (Chr(13) within my text, but it just displays this in my message box text.

Can anyone clarify what I have to type, or give me an example of what it should look like?

Thanks

drawde
OBP's Avatar
OBP OBP is offline
Computer Specs
Distinguished Member with 6,365 posts.
 
Join Date: Mar 2005
Location: UK
Experience: An old Basic Programmer
10-Aug-2006, 11:01 AM #2
The ASCII characters have to be included in your text but outside of any quote marks, so to include a return in your text you need something like this
"this bit is text" & CHR$(13) & "this bit is more text"
drawde's Avatar
Junior Member with 18 posts.
 
Join Date: Jul 2006
Location: England
Experience: Intermediate/Advanced
13-Aug-2006, 03:42 PM #3
worked a treat! thanks!
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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

You Are Using:
Server ID
Advertisements do not imply our endorsement of that product or service.
All times are GMT -4. The time now is 01:46 PM.
Copyright © 1996 - 2008 TechGuy, Inc. All rights reserved.
Powered by vBulletin, Copyright © 2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0
Powered by Cermak Technologies, Inc.