Results 1 to 4 of 4
  1. #1
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Filtre with cboxses and two key (2000 sr-1)

    my work is finished 80%...
    But i have see the filtre for each cbox are independent, but i want to use the two cbox similar a two key in the same serching...

    Example i select 4500 in cbox2 and select 101604870001 in cbox2 i want to filtre only all data with this key, in effect show for 4500 all data with 101604870001...

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Filtre with cboxses and two key (2000 sr-1)

    In the ComboBox1_Change and ComboBox2_Change code, you temporarily set an AutoFilter on one column (column D for ComboBox1, column A for ComboBox2).
    If you want the combo boxes to work together, you must set an AutoFilter on both columns A and D.

  3. #3
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Filtre with cboxses and two key (2000 sr-1)

    not completly understand:-(

    post in wich part of code i modify with you suggestion, please...

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Filtre with cboxses and two key (2000 sr-1)

    In ComboBox1_Change and ComboBox2_Change you define a range consisting of one column, then apply AutoFilter to this range. Instead of this, apply the AutoFilter to the entire data range, and apply it to columns A and D.

Posting Permissions

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