Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2011
    Posts
    2

    Unanswered: display data using dropdown

    hi,

    i have 5 categories and 10-30 set of records in each category.
    i created a dropdownlist to select the category
    while selecting the category respective records should be displayed
    i have uploaded a sample excel file

    thanks,
    ebby
    Attached Files Attached Files

  2. #2
    Join Date
    Jan 2002
    Location
    Bay Area
    Posts
    511
    Attached is an Excel 2003 solution that uses a command button on the worksheet that runs Visual Basic code and opens a form with a list box to display a list of the categories retrieved from Sheet2.
    After you select a category from the list and click OK, rows in Sheet1 that fall outside of the category you choose are hidden, accomplished by Visual Basic code.
    The workbook open event contains code that hides rows 2-100 in Sheet1, giving you a blank sheet and the command button to start with.
    Attached Files Attached Files

  3. #3
    Join Date
    Jan 2011
    Posts
    2

    thanks

    thanks it is working fine....
    this is what i am looking for.
    thanks a lot...

Tags for this Thread

Posting Permissions

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