+ Reply to Thread
Results 1 to 2 of 2

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

  1. #1
    Registered User
    Join Date
    09-28-2012
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    1

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

    Excel 2010 problem – Linked Scroll bar and text box control for values less than 1I 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 doI 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 doBasically, 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.
    Thanks! I hope someone can help,

  2. #2
    Registered User
    Join Date
    02-07-2013
    Location
    Mass
    MS-Off Ver
    Excel 2010
    Posts
    1

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

    Was a solution ever found for this? I am interested as well.

    Pat

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1