Excel 2010 problem – Linked Scroll bar and text box control for values less than 1

Armo

New member
Joined
Sep 28, 2012
Messages
1
Reaction score
0
Points
0
Excel 2010 problem – Linked Scroll bar and text box control for values less than 1
I want a scroll bar and text box control that feed back into each other for values in the range 0-1, at steps of 0.1.
What I can do
I can insert an active x scroll bar, with a range of 0-10, and link it to a cell, for example D9, using the properties box.
I can insert an active X text box, and also link it to cell D9 using the properties box
This allows me to use the scroll bar to control a value between 0 and 10, or input a value in the textbox, which feeds back through D9 to re-position the slider.
What I want to know how to do
Basically, the above, but for values in the range 0 – 1, in stages of 0.1
I have the following code which can alter the range in a cell how I want
Private Sub ScrollBar2_Change()
Range("d20").Value = ScrollBar2.Value / 100
End Sub
Now, if I create an active x text box, and link it to cell d20, the text box will display changes I make using the scroll bar, but if I input a number into the textbox, it won’t re set the scroll bar to that value.

I have attached an example xlsm file with my problem in

Thanks! I hope someone can help me
 

Attachments

  • Excel questions.xlsm
    27.6 KB · Views: 41
Top