Results 1 to 1 of 1

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

  1. #1

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



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •