Announcement

Collapse
No announcement yet.

Embed Label Into Scrollbar Control

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

  • TheDude
    started a topic Embed Label Into Scrollbar Control

    Embed Label Into Scrollbar Control

    I have seen various spreadsheets with a label embedded into their form or control scroll bars, usually a percentage meter. I am curious how to make a dynamic label embed into a control scroll bar that would change based upon the referenced cell of the scroll bar.

    I am seeking to have the dynamic label "Current Delay" ##"M"_);[=0]"No Delay";General show inside the scroll bar itself.

    Any suggestions would be appreciated

  • TheDude
    replied
    Re: Embed Label Into Scrollbar Control

    Thanks Dave,

    Here is the link to the new post http://www.ozgrid.com/forum/showthre...418344#Similar

    Don't worry about it if it becomes time consuming.

    Regards,

    -Dude

    Leave a comment:


  • Dave Hawley
    replied
    Re: Embed Label Into Scrollbar Control

    Dude, if you start a thread stating how exactly you want the scroll bar and label to interact, I'll take a look.

    Leave a comment:


  • TheDude
    replied
    Re: Embed Label Into Scrollbar Control

    Thanks Dave,

    Doh! I see how this will work, I am new to the control buttons. I will get it working when I have learned more about VBA.

    Thanks again,

    -The Dude

    Leave a comment:


  • Dave Hawley
    replied
    Re: Embedding A Label Into A Control Scrollbar

    You would simply add the Label Control to the Scroll Bar Control and code the ScrollBar1_Change() Procedure.

    Leave a comment:

Working...
X