VBA:How conncect Scrollbar and Textbox in Userform

[johnston]

I have a userform with a scrollbar and textbox. How do you code it so that the scrollbar connects to the textbox? For example, I want the textbox to

increase/decrease by a value ​

each time you click the up/down-arrow on the scrollbar. Anything helps!

 

[My Aswer Is This]

Why not set your texbox to AutoSize and Textwrap to false
Textbox will grow as you enter more text.
Use Shift enter to start new line.

 

[Marcelo Branco]

Do you want to set the value of the Textbox equal to the value of the Scrollbar?

If so, maybe...

Private Sub ScrollBar1_Change()
    Me.TextBox1 = Me.ScrollBar1.Value
End Sub

M.

 

[My Aswer Is This]

Do you want to set the value of the Textbox equal to the value of the Scrollbar?

If so, maybe...

Private Sub ScrollBar1_Change()
    Me.TextBox1 = Me.ScrollBar1.Value
End Sub

M.

Curious.
How does a scrollbar have a value?

 

[My Aswer Is This]

Please explain again what you want to happen when you click the scrollbar.
Do you want the value in the textbox to increase like if textbox1 has the value 1 then when you click on scrollbar you want textbox value to now be two.

Or do you want the size of the textbox to increase?

 

[Marcelo Branco]

Curious.
How does a scrollbar have a value?

Using the properties Min and Max of the Scrollbar, for example
Min = 1
Max = 100
when the form is initialized Scrollbar=1

M.

 

[Jaafar Tribak]

Maybe you should take a look at the form's scroll event :

Private Sub UserForm_Scroll(ByVal ActionX As MSForms.fmScrollAction, _
ByVal ActionY As MSForms.fmScrollAction, ByVal RequestDx As Single, _
ByVal RequestDy As Single, ByVal ActualDx As MSForms.ReturnSingle, ByVal ActualDy As MSForms.ReturnSingle)