Display Text In a Msgbox On Multiple Lines
Request a callback

We'll call during UK business hours

Name:
Number:
0207 987 3777

Hints and tips home » VBA hints and tips » Display Text In a Msgbox On Multiple Lines

Display Text In a Msgbox On Multiple Lines

When displaying text in a MsgBox you may need to show it over multiple lines. To do this use:

vbCrLf

As in:

MsgBox "The System has detected an error." & vbCrLf & "Contact your System Administrator"

The first sentence in quotes will appear above the second in the MsgBox.


Added by Carlos on 24th November 2006

More VBA hints and tips, like:



Management Training courses LondonCould not connect to admin db:


Please tell us/web development about this error (copy and paste into an e-mail):
MySQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1
Line: 5152
Actual SQL Query: insert into best_datarating (datarating_ID, datarating_AttachType, datarating_AttachID, datarating_Variable1, datarating_Variable2, datarating_Rating, datarating_Sample) values (null, "application", 25, 0, 0, 0, )
Reported by: function sqlQueryBest()
When viewing (PHP_SELF): /cms/tips.php
Query string from URL: resource_id=405

(Can not yet provide accurate rating)
Microsoft Certified Partner Institute of Leadership and Management - Certified Courses Learning and Performance Institute - Accredited Training Provider Security Seal verified by visa, mastercard securecard

Connect with us: Google+ · Facebook · Twitter · LinkedIn · Pinterest

2nd Floor, CA House, 1 Northey Street
Limehouse Basin, London, E14 8BT
United Kingdom