Beginner - Excel - How to insert new line in Label Text

D

duBedat68

Hi once again,
I would be pleased if anyone could guide me as to how to insert a new line
in an Excel UserForm Label Text.

************************************
************************************
Private Sub UserForm_Initialize()

frmChild.lblChildShowParentDetails.Caption = _
frmParent.txtParentFirstName.Text & " " _
& frmParent.txtParentSurname.Text

frmChild.lblChildShowAddressDetails.Caption = _
frmParent.txtParentStreetAddress.Value & nbln _
& frmParent.txtParentSuburb.Value & " " _
& frmParent.txtParentPostCode.Value
************************************
************************************

The problem with this code is that if the address if very long, it looks
very messy.

I have tried in vein to find the syntax for "NEW LINE", I vaguely remember
something about "nbln" but as I said, very vague.

Many Kind regards
duBe
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Beginner - Trouble assigning text to Form Label Caption 5
how to add new row to table in Excel 2003? 3
Line chart categoray axis labels issue - Excel 2007 2
how to start a new text line inside the visio shape paragraph 4
How to insert a New Line into a text field? 3
FP 2003: Replace starts new line after inserting text 6
How to insert ALT+ENTER (new line) with Replace 7
How do I start new line when concatenating text strings in excel? 2

Top