Results 1 to 6 of 6

Thread: Excel Scroll Bar Problem

  1. #1

    Excel Scroll Bar Problem



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

    Hey everyone, I need to make my scroll bar move by 0.1 each time the arrows are clicked (I believe this is the 'small change' option) but when I go to enter it in it comes up with an error message saying "Invalid property Value". Also I've set the minimum to be -1 and the maximum to be 2 however when I scroll to where it should say -1 it has 65535 instead? Any ideas on what I can do?

    Thanks in advance!

  2. #2
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,512
    Articles
    0
    Excel Version
    365
    You don't say whether it's a scrollbar on a sheet or on a user form, nor whether it's an ActiveX or Forms scrollbar. The attached addresses all 3.
    Attached Files Attached Files

  3. #3
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,512
    Articles
    0
    Excel Version
    365
    cross posted:
    http://www.mrexcel.com/forum/excel-q...r-problem.html

    Wadsy, for your information, you should always provide links to your cross posts.
    If you have cross posted at other places, please add links to them too.
    Why? Have a read of http://www.excelguru.ca/content.php?184

  4. #4
    Thanks for the reply P45cal, sorry about the lack of information I'm only new to excel. It's an ActiveX Scroll bar on a sheet, I've done what you showed me in the attached document but when I get to the lowest number I need it still changes to 6552.5.

  5. #5
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,512
    Articles
    0
    Excel Version
    365
    A guess: you haven't set the scrollbar's Min property to 0.

  6. #6
    Ohh I had it as -1 because it needs to go down to -1 but it works now! Thank you so much!

Tags for this Thread

Posting Permissions

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