+ Reply to Thread
Results 1 to 3 of 3

Control Toolbox Scroll Comands - Up/Down

  1. #1
    Registered User
    Join Date
    12-11-2012
    Location
    Norwich
    MS-Off Ver
    Excel 2003
    Posts
    8

    Control Toolbox Scroll Comands - Up/Down

    Hi,

    I need to trigger different macros depending on if a scrollbar is scrolled up or down. I had assumed there would be VBA syntax for scroll up/ scroll down commands rather than just on change but i cannot find these anywhere, if anyone could help it would be much appreciated.

    Many thanks

  2. #2
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Control Toolbox Scroll Comands - Up/Down

    no-there are just scroll and change events so you'd have to store the previous value if you need to know which way it is going
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  3. #3
    Registered User
    Join Date
    12-11-2012
    Location
    Norwich
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: Control Toolbox Scroll Comands - Up/Down

    Thanks mate,

    Thought that might be my only option, wasnt sure if i could store the old value in the change event or not but will give it a try.

    Regards

+ 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