Results 1 to 4 of 4

Thread: Adding a Scrollbar to review data
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    465
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Adding a Scrollbar to review data

    Hello to All!

    The Budget's on Sheet1: 1,960 & 1,965 are contingent upon which Rep and Discipline are selected from drop-down menus, therefore, being that there will always be one number associated with Reading or Language Arts, I can easily extropolate those by using the formula included in this example. However, I'm looking to get creative with the sales numbers.

    As you will notice in Sheet2, I've listed 3 sub-categories for both Reading and Lang Arts. I was hoping that I could somehow include a scroll bar to carry out the following: the fisrt product Ihighest value) in the list would always appear in the cell (BFD), then each time a user clicks the scroll bar, it would input that product into the cell and thus provide a new number as well...so if a user clicked twice (being that BFD is already in the cell) he would then see BFA, then BFC.

    Now, if this is possible, would I need another scroll bar for Language Arts as well?

    Any advice, as always, is greatly appreciated.

    Take Care.

    Anthony

    ******** ******************** ************************************************************************>
    Microsoft Excel - Forecast Template.xls___Running: xl2002 XP : OS = Windows XP
    (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout
    =

    D
    E
    F
    G
    H
    I
    J
    K
    L
    M
    N
    O
    P
    Q
    R
    S
    10
    Sheet1 Sheet2
    11
    Budget Sales StateRepSubjectProductSales
    12
    State Total:New York New YorkSteve M MummReadingBFD300
    13
    New YorkSteve M MummReadingBFA200
    14
    Rep Total:Steven M Mumm New YorkSteve M MummReadingBFC100
    15
    New YorkSteve M MummLanguage ArtsBDJ700
    16
    New YorkSteve M MummLanguage ArtsBDG600
    17
    Discipline:Reading 1,960 New YorkSteve M MummLanguage ArtsBEC500
    18
    BFD 300
    19
    20
    Language Arts 1,965
    21
    BDG 700
    Language_Arts

    [HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
    PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Posts
    465
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Adding a Scrollbar to review data

    By the way, it's not mandatory that it be a scroll bar...whatever works best will suit me just fine.

  3. #3
    Board Regular
    Join Date
    Nov 2002
    Location
    Brisneyland, Australia
    Posts
    301
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Adding a Scrollbar to review data

    Anthony,

    In the Forms toolbar there is a thing called a Spinner. Use the Format control/Control options (via right-click) to link the spinner to the worksheet. Use Vlookup somewhere else in your sheet to convert the numbers produced into your product codes. Then your existing VLookup will pick up the code...on you go...

    Good luck,

    Bruce

  4. #4
    Board Regular
    Join Date
    Mar 2002
    Posts
    465
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Adding a Scrollbar to review data

    Thanks! I'll give it a shot.

    Take Care...

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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