+ Reply to Thread
Results 1 to 2 of 2

Calibrating a horizontal scroll bar formula

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

    Calibrating a horizontal scroll bar formula

    HI all and Happy Memorial Day!

    I originally posted this in VBA as I though it was a code thing, now that I have had time to consider it, it may be a formula issue/resolution?

    I have a sample attached, and in X9 I have the formula =F3+AF4-(F3-D10) which F3 is the Start Date of Project, AF4 is the position of the scroll bar and F3-D10 is the calculation of the start date and lowest date in schedule. This formula starts my calendar date at the formula calculation, =F3+AF4-(F3-D10) and row 10 is the last row in the Freeze Pane.

    So, what I am wondering is there a way to reference the next row after the "Freeze Pane" or row 12 in this sample keeping in mind it will move when scrolled. So, if I scroll to row 30 (In this sample) and row 30 is directly under row 10 "the Freeze Line" then my formula would change to =F3+AF4-(F3-D30) which would move my bar chart to that day in X9 so it will follow the dates in D when scrolling down or up. What ever date in "D" directly below Row 10 is, that would be the formula.

    Any ideas on this. I am not sure if I can reference this in this way.
    Thanks to all,
    Dave
    Attached Files Attached Files

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

    Re: Calibrating a horizontal scroll bar formula

    Moderator,
    Please close this post as I think I need to post in a different forum.
    Thank you

+ 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] Calibrating vertical and horizontal scroll bars
    By davidpierce in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-25-2015, 09:06 AM
  2. getting a horizontal scroll bar in listbox
    By jmoffat in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-22-2014, 08:44 AM
  3. Horizontal scroll bar issue
    By ElTerrible in forum Excel General
    Replies: 1
    Last Post: 07-31-2008, 09:34 AM
  4. [SOLVED] horizontal scroll bar references
    By skihula in forum Excel General
    Replies: 2
    Last Post: 12-28-2005, 01:50 PM
  5. No Horizontal Scroll Bar
    By Screen/Display size in forum Excel General
    Replies: 1
    Last Post: 08-19-2005, 10:05 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