text box in userform (vba)

  reddwarfcrew 21:09 09 Feb 05
Locked

I've got a text box in a userform in vba.

However, the text box only allows for one continual string of text and doesn't allow you to put either returns in or formats it so that when you type it wraps the text in the box.

Hope that makes sense.

Csan anyone help me get a text box in a userform that either allows you to put returns in, or at least how to format it so that the text wraps.

Thanks.

  VoG II 21:22 09 Feb 05

Right click the box, Properties. In the left hand pane scroll down and set MultiLine to True.

To start a new line press CTRL + Enter.

  EdFrench 21:30 09 Feb 05

Or use a memo box instead.

  reddwarfcrew 21:33 09 Feb 05

couldn't see the wood for the trees!!!

  VoG II 21:42 09 Feb 05

It isn't exactly obvious.

I think MS made things unnecessarily complicated with UserForms. Dialog Sheets were much easier, and still exist.

This thread is now locked and can not be replied to.

Best phone camera 2016/2017: Galaxy S7 vs iPhone 7 vs Google Pixel vs HTC 10 Evo vs OnePlus 3T vs…

1995-2015: How technology has changed the world in 20 years

These are the Best Christmas Ads and Studio Projects of 2016

Super Mario Run preview | Hands-on first impressions of Super Mario Run: Mario's iPhone & iPad…