+ Reply to Thread
Results 1 to 43 of 43

Scroll Bar and Current Value. Min and Max Values

Hybrid View

  1. #1
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,482

    Re: Scroll Bar and Current Value. Min and Max Values

    so what determines when the scroll bar min and max changes??
    Cheers
    Andy
    www.andypope.info

  2. #2
    Registered User
    Join Date
    04-18-2011
    Location
    UK
    MS-Off Ver
    Excel 2010
    Posts
    92

    Re: Scroll Bar and Current Value. Min and Max Values

    thats the problem im trying to solve.

    As default in example the scroll is selected by the user to current 100 (C7). min 50 and max 150.(has to be done manually)

    if i change scenario as in C7 from 100 to say 1,000, then i need the default to change to 1,000, and the min to say 500 and max 1500. (higher current values requires higher min and max values)

    thats the solution im looking for


    thanks

+ 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] Set PivotTable Filter to Current Day, Current Week, Current Month, or Current Year
    By EnigmaMatter in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-30-2014, 08:31 AM
  2. [SOLVED] copy and paste in current active cell, and need current date then scroll down 140 lines
    By vengatvj in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-04-2013, 03:40 AM
  3. [SOLVED] Frozen panes, using macro to add entries. want the sheet to scroll to the current row.
    By emilyloz in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 07-12-2013, 11:15 AM
  4. Scroll bar (Form Control) - Resetting the scroll bar to particular values
    By Vishb in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-29-2011, 04:10 AM
  5. scroll along row looking for values?
    By newdude in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-27-2007, 01:26 AM
  6. Replies: 1
    Last Post: 04-18-2006, 11:40 AM
  7. Replacing Linked Cell Values w/ Current Values
    By TomCat in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-10-2006, 07:25 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