Closed Thread
Results 1 to 5 of 5

Calibrating vertical and horizontal scroll bars

  1. #1
    Forum Contributor
    Join Date
    04-09-2015
    Location
    Jamestown, TN
    MS-Off Ver
    2010
    Posts
    111

    Calibrating vertical and horizontal scroll bars

    Hi all,
    Is there a way to get the scroll bars coordinated so that when I scroll down, the calendar scroll bar moves with the coordinating dates with the schedule? Sample Attached.
    Attached Files Attached Files

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Calibrating vertical and horizontal scroll bars

    I'm sorry but this question isn't clear. Are you saying that when you scroll down using the built-in scroll bar for the worksheet window, that you want your scroll bar located at AF4 to also scroll to the right by some corresponding amount?

    One of the reasons that it isn't clear is that it's hard to imagine why you would want to do this. The only thing I can imagine is that as you scroll down to see more tasks, you also want to see the bars for those tasks at the right. But the bars could be anywhere. There's no guarantee that things will line up.

    There is no built-in way to detect window scrolling in VBA. It is possible to build a way to do it but it's a little complicated and I've never done it myself. Here is a page with more info.

    http://www.cpearson.com/excel/DetectScroll.htm
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Forum Contributor
    Join Date
    04-09-2015
    Location
    Jamestown, TN
    MS-Off Ver
    2010
    Posts
    111

    Re: Calibrating vertical and horizontal scroll bars

    Thanks,
    I will do some research on it. Yes, I wasn't sure if this was possible or not. Basically when I scroll down the list, I want the scroll bar at AF4 to move with the dates from the tasks. It may not even be tied into the built in scroll bar actually, it may be as simple as setting the home made scroll AF4, to match some type of the row & date so that when I do scroll down, it moves the Gantt to be visible with the task. I guess if anyone has done this, maybe they will give me some guidance?
    Thank you Jazzer

  4. #4
    Forum Contributor
    Join Date
    04-09-2015
    Location
    Jamestown, TN
    MS-Off Ver
    2010
    Posts
    111

    Re: Calibrating vertical and horizontal scroll bars

    Hi all,
    I have been thinking about this and is there a way of referencing the cell directly below the "Freeze Pane" (as it changes when scrolled) ? In X9 I have the formula "=F3+AF4-(F3-D10)" F3 being the project start date, AF4 being the position of the horizontal scroll bar, and F3-D10 being the start date - the lowest day of project, this sample 4/20/2015. This formula put the gantt chart (so to speak) at the lowest possible day (D10) in X9.

    I am thinking if I could get something on_change? that it would change that formula to the Row/Cell in "D" it would move the scroll or gantt to that day in X9? On this sample, if you scrolled down and Row 30 was directly below "The Freeze Pane" then the formula for this would be something like "=F3+AF4-(F3-D30)" ? Is this possible? Not sure if you can reference the "Freeze Pane Row" or not? If so I think this could be rather simple maybe?
    Last edited by davidpierce; 05-25-2015 at 07:22 AM.

  5. #5
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Calibrating vertical and horizontal scroll bars

    As per forum rules, it's not possible to have the same thread in 2 different sub forum. So as you posted in "Excel functions& formulas" section, this thread is closed.
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Want to hide the scroll bars( both horizontal and vertical) in one worksheet
    By ananthbulusu in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-05-2013, 02:18 PM
  2. Have horizontal bars--want to indicate average with vertical line....
    By sarahsez in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-10-2012, 04:51 AM
  3. Force Display of Vertical Scroll Bars
    By jpruffle in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-04-2009, 12:55 PM
  4. Horizontal Bars Scroll-Bars!
    By e4excel in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 03-07-2009, 03:10 PM
  5. [SOLVED] horizontal & vertical scroll bars
    By labrev in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-21-2005, 12:06 PM

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