+ Reply to Thread
Results 1 to 2 of 2

ScrollBar - Min Value on right side?

  1. #1
    Valued Forum Contributor
    Join Date
    04-24-2014
    Location
    United States
    MS-Off Ver
    Office 365 ProPlus
    Posts
    853

    ScrollBar - Min Value on right side?

    I'm working with a scroll bar and cell link setup in conjunction with an offset in a formula.

    And I have a sheet with columns of dates that will change when adjusting the scroll the bar, and those dates/months run lowest to highest. ie January in Column A, December in Column L

    It all works as 'expected' that when moving the scroll the bar, the dates will update based on the linked cell and the offset (have 36 months, and showing 12 via a scroll bar)

    But the problem is, the scroll bar is 'backwards'. When the scroll bar thumb is on the far left, the linked cell will be 0. But I want that to on the far right side if possible? Essentially flip the scroll bar 180 degrees.

    Can that be done or do i need to rethink the data and offsets?

  2. #2
    Valued Forum Contributor
    Join Date
    04-24-2014
    Location
    United States
    MS-Off Ver
    Office 365 ProPlus
    Posts
    853

    Re: ScrollBar - Min Value on right side?

    Edit:

    Got it solved. In my case, I have 24 months of data, a cell link in Z24 and max value in the scroll bar of 24. So essentially 24 minus the cell link. So something like this worked:
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to create a month and Year-to-date column side by side in pivot table
    By Dewdrop in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-13-2017, 02:25 AM
  2. Replies: 11
    Last Post: 05-17-2017, 12:52 PM
  3. [SOLVED] Set Excel 2010 as default program when installed side-by-side with 2013
    By AlvaroSiza in forum Excel General
    Replies: 1
    Last Post: 08-31-2013, 06:45 PM
  4. VBA to copy data from multiple sheets side-by-side into one sheet matching date
    By MHCapcog in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 04-02-2013, 06:11 PM
  5. Change ScrollBar Max value when a second ScrollBar vale is changed?
    By Jon Henry in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-11-2013, 06:47 PM
  6. Replies: 0
    Last Post: 04-19-2009, 10:53 PM
  7. [SOLVED] scrollbar reslut makes another scrollbar to show
    By Patrik in forum Excel General
    Replies: 0
    Last Post: 04-18-2005, 11:06 AM

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