CODEWITHSUNDEEP
exceltextboxreturnuserformmultiline
SpencerDudeUK
SpencerDudeUK

Reputation: 9

Carriage returns in userform textbox

I am passing a string through to a userform textbox, and cannot get the text to recognise where I want carriage returns.

The string contains several 'vbNewLine' entries (I've tried alternatives like vbCrLf, etc), but can't get it to work. I simply get a one line text string (albeit word-wrapped) with a symbol where the carriage return should be...what am I not doing?

Upvotes: 0

Views: 88

Answers (1)

Black cat
Black cat

Reputation: 6271

For this to achieve, set the MultiLine property to True. If this property is False the WordWrap property is ignored.

Upvotes: 1

Related Questions