+ Reply to Thread
Results 1 to 6 of 6

UserForm LIstbox filter with multiple Criteria

  1. 12-19-2021, 06:42 AM #1
    Rajeshkumar R
    Rajeshkumar R is offline
    Forum Contributor
    Join Date
    01-07-2012
    Location
    Bangalore
    MS-Off Ver
    Office 365
    Posts
    368

    UserForm LIstbox filter with multiple Criteria

    Dear Friends,

    In attached thread My Previous concern had been cleared from your Support…

    https://www.excelforum.com/excel-pro...t=#post5608678

    In The same Code, I am trying to add one more filter criteria as red highlighted below

    Though With below code, list box show the proper Result, The Result showing without Column Heading in Listbox…

    Could you please help me in amending below code, which shows data with column heading and considering two criteria which highlighted below

    Please Login or Register  to view this content.
    Thanks & Regards,
    Rajeshkumar R
    Last edited by Rajeshkumar R; 12-20-2021 at 01:06 PM. Reason: Query Resolved
    Reply With QuoteRegister To Reply
  2. 12-19-2021, 01:19 PM #2
    MikeVol
    MikeVol is online now
    Valued Forum Contributor
    Join Date
    12-30-2020
    Location
    Odessa / Ukraine
    MS-Off Ver
    2021
    Posts
    300

    Re: UserForm LIstbox filter with multiple Criteria

    Rajeshkumar R Hi! Maybe like this, but it's not certain:
    Please Login or Register  to view this content.
    Why is this line 
    Please Login or Register  to view this content.
    in your procedure Private Sub ComboBox1_AfterUpdate()?
    And right there you want Private Sub TextBox7_Change() to make it work for you.
    What are you doing yourself without knowing it? Sorry if something is wrong.
    Reply With QuoteRegister To Reply
  3. 12-19-2021, 10:26 PM #3
    Rajeshkumar R
    Rajeshkumar R is offline
    Forum Contributor
    Join Date
    01-07-2012
    Location
    Bangalore
    MS-Off Ver
    Office 365
    Posts
    368

    Re: UserForm LIstbox filter with multiple Criteria

    Dear MikeVol,

    Even with below suggested code, the Column Heading not getting appeared in List Box Please...

    Please Login or Register  to view this content.
    Coming To TextBox.7 I got your Point of View... shall correct the code accordingly.

    Thanks & Regards,
    Rajeshkumar R
    Reply With QuoteRegister To Reply
  4. 12-20-2021, 05:01 AM #4
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,219

    Re: UserForm LIstbox filter with multiple Criteria

    Perhaps...Untested...
    Please Login or Register  to view this content.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!
    Reply With QuoteRegister To Reply
  5. 12-20-2021, 01:05 PM #5
    Rajeshkumar R
    Rajeshkumar R is offline
    Forum Contributor
    Join Date
    01-07-2012
    Location
    Bangalore
    MS-Off Ver
    Office 365
    Posts
    368

    Re: UserForm LIstbox filter with multiple Criteria

    Dear sintek,

    Thanks a lot for your Support... Your suggestion worked amazingly...

    Thanks & Regards,
    Rajeshkumar R
    Reply With QuoteRegister To Reply
  6. 12-21-2021, 02:47 AM #6
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,219

    Re: UserForm LIstbox filter with multiple Criteria

    Glad I could assist...Tx for rep +
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. excel 2003 userform listbox to autofilter. Multiple criteria (beyond two)
    By vbapadawan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-24-2015, 01:36 PM
  2. Filter listbox in userform - VBA
    By mopan in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 05-18-2015, 04:36 AM
  3. Filter by Multiple Criteria coming from listbox (that can be different sizes)
    By djblois1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-19-2014, 04:43 PM
  4. Filter Data with a userform that has multiple criteria
    By TubbzUK in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-16-2014, 04:17 PM
  5. Listbox to filter multiple criteria
    By reggie1000 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-04-2013, 12:41 PM
  6. userform listbox
    By tsiguy96 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-14-2013, 11:09 PM

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1