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

[Guest]

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

 

[NickHK]

duBe,
try "vbnewline".

NickHK

 

[Guest]

Tops, thanks heaps NickHK,
it looks easy when you know how.

Cheers
duBe