How to enter CRLF in textbox control of user form in Excel

[TheAceMan1]

Howdy All ...

How can this be done?

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[SkipVought]

hi,

Textbox.Text = "Now is the time" & vblf & "for all good men"

I simply use vblf but whatever!

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[PHV]

Did you try Ctrl+Enter or even Alt+Enter ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[TheAceMan1]

SkipVought: I should've mentioned I need to do this when the user form is open (thru the user interface)! Sorry about that.

[blue]Did you try Ctrl+Enter or even Alt+Enter ?[/blue]

Yes I did! Thats why I posted ... they don't work. Alt+Enter works fine in a cell and this is what the users know to do to add additional info in a two line cell.

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[TheAceMan1]

Got It! ...

Hand to set the [blue]MultiLine[/blue] property to true. [blue]Ctrl+Enter[/blue] now works.

Thanks for the assist.

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[PHV]

Set the EnterKeyBehavior property to True ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886