I'm not trying to be a smart alec (much is lost in text-only
communication), but that's the way the scroll bars work in Microsoft's
Excel textbox control.


Shawn wrote:
Great. Two issues. Why doesn't the scroll bar appear when the userform
initializes? It doesn't appear unless I click the text box.

2nd...when I click the text box it automitically jumps to the end of the
text instead of staying at the begining???


--
Thanks
Shawn


" wrote:

Oh, and set the "MultiLine" property of the textbox to "True" as
well...


wrote:
Rather than having two separate controls for that, wouldn't you simply
want to set the "ScrollBars" property of the textbox to "2 -
fmScrollBarsVertical"?


Shawn wrote:
I have never used a scroll bar in conjunction with a text box. Please help.

I have userform CCLCFC

I have text box txtbxexplain

I have scrollbar scbrexplian

Via VBA I want to tie scbrexplain to txtbxexplain so that when one uses the
scrollbar he/she can scroll up and down through the information in the text
box. Please help.



--
Thanks
Shawn