text box size problem

  • Thread starter Thread starter scrabtree23
  • Start date Start date
S

scrabtree23

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
 
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.
 
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.
 
Back
Top