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
|