Displaying text in textbox

Europom · March 12th, 2007, 11:18 AM

I'm very new to VBA and would appreciate any help.

I'm trying to display several lines of text in a text box, using & vbcrlf at the end of each line.
However, the text only appears on one line and scrolls left and right.

Can anyone help me????

Shasur · March 12th, 2007, 11:27 PM

Set the MultiLine property of the TextBox as True

You will Get it!!!

Cheers
Shasur

http://www.vbadud.blogspot.com

Europom · March 14th, 2007, 03:03 PM

Thanks Shasur, I knew it had to be something simple (or stupid)

.

The lesson here is to look closer at the properties. I'll remember next time before bothering the computer community. :D

eparho · March 19th, 2007, 03:04 PM

Hi
Would you know how to set the Multiline property programmatically after a text box has been added to a worksheet using the Controls toolbox? I've tried everything no luck...
Thanks greatly for any feedback

Shasur · March 31st, 2007, 06:28 AM

Hi eParho

You can set the Multiline property programmatically

TextBox1.MultiLine = True

http://www.vbadud.blogspot.com