Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Aug 2006
    Thanked 0 Times in 0 Posts
    Dear Excel Experts

    I inserted a scroll bar from the forms tool bar into a sheet called “dashboard”. An offset formula is used to display 10 consecutive values from the sheet with the raw data in the scrollable table. The scroll bar property maximum value in the format control is set at 191.
    To view data from different sources in the same scroll table I have inserted 5 option buttons and depending which one is selected a number between 1 and 5 is inserted in cell D7 (Sheet 3).Not all worksheets have the same number of cells with data i want to have displayed in the scroll table. My question is can the maximum value of the scroll bar (from the Forms Toolbar) that is entered in the Format Control be changed by a macro to a different value depending which option button has been selected and what code would I use for this purpose?
    Any advice would be greatly appreciated. Thank you. I am using Excel 2000


  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Weert, Limburg, Netherlands
    Thanked 0 Times in 0 Posts
    The Syntax is as follows:

    ActiveSheet.ScrollBars("Scroll Bar 1").Max = 1000
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    Professional Office Developers Association

Posting Permissions

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