Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Location
    Belfast, UK
    Posts
    87

    Unanswered: filter combobox based on another combobox?

    Hi,

    using the Excel form controls is it possible to filter one combobox based on another one?

    So combo1 sourced from C1:C3
    item1
    item2
    item3

    Combo2 sourced from E1:F6
    Col1 , Col2
    item1, subitem1
    item1, subitem2
    item2, subitem3
    item2, subitem4
    item3, subitem5
    item3, subitem6

    What i want is combo2 to only display the values in Col2 were Col1 equals the value in combo1

  2. #2
    Join Date
    Dec 2003
    Location
    Belfast, UK
    Posts
    87

    Solution Found

    Found the solution to my problem here:

    http://www.contextures.com/xlDataVal02.html

    I was looking for something complicated and it turned out to be something simple.

Posting Permissions

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