text box size problem
 

I have a text box on a userform that ties to a cell in one
of my worksheets. The information in the cell is too long
and therefore the textbox can't hold it all. I don't want
to make the textbox larger, or reduse the font size. I
would like to add a scroll bar???

SDC

text box size problem
 

Scrabtree23,

Go View - Toolbars - Control Toolbox
Here you will find a different kind of textbox, similar, but
with some additional features. Insert one into your sheet.
Right click the textbox (in design mode)* and choose
properties. Set the following properties:

Multiline - True
Scrollbars - 2 - fmScrollBarsVertical
LinkedCell - your linked cell (ie A1)
If you want the textbox to be flat like other textboxes
SpecialEffect - 0 - fmSpecialEffectFlat
BorderStyle - 1 - fmBorderStyleSingle

Dan E

*To enter design mode view the Visual Basic Toolbar
View - Toolbars - Visual Basic. On it you will find a
button which will allow you to switch from design mode
to normal and back again.

"scrabtree23" wrote in message ...
I have a text box on a userform that ties to a cell in one
of my worksheets. The information in the cell is too long
and therefore the textbox can't hold it all. I don't want
to make the textbox larger, or reduse the font size. I
would like to add a scroll bar???

SDC

text box size problem
 

Right click on the textbox in the VBE/Userform and select properties.
Change the WordWrap property and Multiline properties to true.
Then look at the scrollbars property and select the setting you want.

--
Regards,
Tom Ogilvy


"scrabtree23" wrote in message
...
I have a text box on a userform that ties to a cell in one
of my worksheets. The information in the cell is too long
and therefore the textbox can't hold it all. I don't want
to make the textbox larger, or reduse the font size. I
would like to add a scroll bar???

SDC