userform text box and a scroll bar

S

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.
 
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"?
 
S

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???
 
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???
Click to expand...
 

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

Similar Threads

Scroll does not show preview 0
How to make scroll bar permanently visible, Word 365 0
Vertical scrollbar screwed up 4
How do I set focus (and select text) on a text box on a modeless userform? 0
Reset and display scoll bar in text box 0
Link a text box based on drop down box with four options MS Word 365 0
ScrollBars in 6.5 1
scrolling 2 frames simultaneously 2

Top