Announcement

Collapse
No announcement yet.

Embed Scrollbar Track With Text Box

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Embed Scrollbar Track With Text Box



    I am attempting to merge a scroll bar and an activeX text box. I currently have a horizontal scroll bar that links to a cell with values from 1-20, A dynamic label in the adjacent cell changes when the scroll bar moves. I need the label to be inside the scroll bar track/tray. I was told an activeX text box would do the trick. However, i am new to VBA and activeX text boxes any code or solution to this problem is appreciated.

    Conditions:
    The slider and the track should overlay the text box label
    The track should be transparent but on top of the label
    The label should be a perfect fit to the slider's tray

    Here is a reference to the scroll bar labels


    I have posted an example file of what i am attempting to achieve.

    Thanks,

    -The Dude
    Attached Files
    The Dude Abides

  • #2
    Re: Embed Scrollbar Track With Text Box

    Simplest thing would be to use 2 buttons instead.
    Attached Files

    Cheers
    Andy

    Comment


    • #3


      Re: Embed Scrollbar Track With Text Box

      Andy,

      Great idea, the only issue is when the scrollbar has a higher value and single clicks would take forever. If i can't find the solution i will use your idea. However, I have seen this work on other spreadsheets.

      Thanks again,

      -Dude
      The Dude Abides

      Comment

      Working...
      X