userform text box and a scroll bar

G

Guest

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.
 
C

crferguson

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

Guest

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???
 
C

crferguson

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.

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???
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top