Hello everyone
Can anyone tell me please how to make a newline in a textbox vba if the text entered is longer than the lenght of the TextBox.
Thank you.
Hello everyone
Can anyone tell me please how to make a newline in a textbox vba if the text entered is longer than the lenght of the TextBox.
Thank you.
Please Login or Register to view this content.
Where is the textbox located and how was it created?
If it's a textbox Shape on a worksheet you can just press ENTER to get a new line.
If it's an ActiveX textbox on a worksheet (or a textbox on a userform) set the MultiLine property to True and EnterKeyBehaviour to True and you can also use ENTER.
If posting code please use code tags, see here.
Hi,
I was thinking it was the Visual Basic constant of "vbCrLf" instead of "Newline" .
See http://www.programmersheaven.com/mb/...and-vbnewline/
It looks like either will work, depending on the platform.
See more about Visual Basic Constants at http://msdn.microsoft.com/en-US/libr...(v=vs.80).aspx
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks