userform text box and a scroll bar

[Shawn]

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

[crferguson@gmail.com]

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

[crferguson@gmail.com]

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


crferguson@gmail.com 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

[Shawn]

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


"crferguson@gmail.com" wrote:

> Oh, and set the "MultiLine" property of the textbox to "True" as
> well...
>
>
> crferguson@gmail.com 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
>
>

[crferguson@gmail.com]

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
>
>
> "crferguson@gmail.com" wrote:
>
> > Oh, and set the "MultiLine" property of the textbox to "True" as
> > well...
> >
> >
> > crferguson@gmail.com 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
> >
> >