Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Mar 2002
    Location
    Western NY, USA
    Posts
    157
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Setting Min/Max scrollbar values dynamically (2003 sp2)

    I have a large list of values, of which I wish to chart a subset. For example I may have 100 rows for each of 20 assembly stations. I want to chart one station. Using the Offset formula, I have a named range to select the rows corresponding with the station number entered into cell B1.

    Here is my dilemma. I want to provide the users with a scroll bar to select the station. However, I need to dynamically set the Min and Max values for the scroll bar.

    Me.Shapes("sbStation").Adjustments(x) = 10 gives me a permissions error.
    Me.Shapes("sbStation").Min = 10 is not valid.

    The scrollbar ignores cell validation.

    I do not want to select the scrollbar to change.
    me.Shapes("sbStation").select
    with selection ...

    So how do I accomplish creating dynamic min/max for the scrollbar. Thanks.

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Setting Min/Max scrollbar values dynamically (2003 sp2)

    If it's from the Forms toolbar you can use either:
    <code>activesheet.scrollbars("sbStation").min</code>
    or:
    <code>activesheet.shapes("sbStation").oleformat.ob ject.min</code>
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Setting Min/Max scrollbar values dynamically (2003 sp2)

    Forgot to mention, if it's from the Control Toolbox, you can use the catchy:
    <code>activesheet.shapes("sbStation").oleformat.ob ject.object.min</code>
    Regards,
    Rory

    Microsoft MVP - Excel

Posting Permissions

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