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.

Huawei P10 review

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

How VR is being used to simulate space

New iPad, iPhone SE & Red iPhone 7 on sale now