+ Reply to Thread
Results 1 to 14 of 14

how can i search in listbox by combobox

  1. #1
    Registered User
    Join Date
    05-25-2018
    Location
    jordan
    MS-Off Ver
    20016
    Posts
    8

    how can i search in listbox by combobox

    hi all
    anyone help me
    i have small project with 3 forms

    form (alma fandi) for add data to sheet 1 ---- its have some problem i hope to fix it i think because listbox1

    form 2 done
    form3 this made me mad

    i have listbox1 and i wont to filter it by combo box between tow date
    i try many time but nothing
    this photo show you
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by alma_fandi; 05-29-2018 at 05:48 PM.

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    Re: search in listbox

    Can't help you am missing a DLL for the Microsoft Common Controls, probably for the calendar.
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

  3. #3
    Registered User
    Join Date
    05-25-2018
    Location
    jordan
    MS-Off Ver
    20016
    Posts
    8

    Re: search in listbox

    [CENTER]Mr Keebellah
    thx
    Last edited by alma_fandi; 05-27-2018 at 05:58 PM.

  4. #4
    Registered User
    Join Date
    05-25-2018
    Location
    jordan
    MS-Off Ver
    20016
    Posts
    8

    Re: search in listbox

    Mr Keebellah



    You can change DTPicker1 to the text box 'I want to filter data / no matter how
    thx
    Last edited by alma_fandi; 05-27-2018 at 06:03 PM.

  5. #5
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    Re: search in listbox

    I understand that I can change the datepicker, but first rule when writing macros is that you must always use this is to use controls that are always available and if not include information of non-standard controls used and where to find them.

    I will see what I can do for you and if I can help

  6. #6
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    Re: search in listbox

    Well it's clear it doesn't work here !!!

    In your screen shot you show two ComboBoxes and you speak about Textboxes.

  7. #7
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,210

    Re: search in listbox

    Give this a go...
    Select dates then, select employee from combobox
    Attached Files Attached Files
    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!!!

  8. #8
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,873

    Re: search in listbox

    Rule 08: Cross-posting Without Telling Us

    Your post does not comply with Rule 8 of our Forum RULES. Do not cross-post your question on multiple forums without telling us about your threads on other forums.

    Post a link to any other forums where you have asked the same question. If you have fewer than 10 posts here, you will not be able to post a link, but you must still tell us where else you have asked the question.

    Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

    Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

    Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

    No further help to be offered, please, until the OP has complied with this request.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  9. #9
    Registered User
    Join Date
    05-25-2018
    Location
    jordan
    MS-Off Ver
    20016
    Posts
    8

    Re: search in listbox

    Quote Originally Posted by sintek View Post
    Give this a go...
    Select dates then, select employee from combobox

    thx allot
    i need to search between date ( visit date column i )
    Last edited by alma_fandi; 05-28-2018 at 05:55 PM.

  10. #10
    Registered User
    Join Date
    05-25-2018
    Location
    jordan
    MS-Off Ver
    20016
    Posts
    8

    Re: search in listbox

    Quote Originally Posted by Keebellah View Post
    Well it's clear it doesn't work here !!!

    In your screen shot you show two ComboBoxes and you speak about Textboxes.
    you said Can't help you am missing a DLL for the Microsoft Common Controls, probably for the calendar.
    so i Suggestion to change the combobox to text box

  11. #11
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: search in listbox

    Maybe first do what is asked in #8

    Kind regards
    Leo

  12. #12
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: search in listbox

    Indeed, Leo is correct.

    Please place a link to your cross post(s) in your initial post to comply with the forum rules.
    HTH
    Regards, Jeff

  13. #13
    Registered User
    Join Date
    05-25-2018
    Location
    jordan
    MS-Off Ver
    20016
    Posts
    8

    Re: search in listbox

    Quote Originally Posted by jeffreybrown View Post
    Indeed, Leo is correct.

    Please place a link to your cross post(s) in your initial post to comply with the forum rules.
    sorry i changed it

  14. #14
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,873

    Re: how can i search in listbox by combobox

    I see no link or reference to a cross post.

    No further help to be offered, please, until the OP has complied with this request.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Listbox Search - 2nd Row's Column value in Listbox
    By kprasad in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-26-2017, 08:05 AM
  2. search name in listbox
    By hkbhansali in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-04-2016, 08:37 AM
  3. Search value and add the row value in listbox
    By camahaveer in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-31-2015, 10:44 PM
  4. search in listbox
    By nyfmpha in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-02-2015, 10:37 AM
  5. Search in a listbox
    By Jddoyon in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-01-2014, 01:53 PM
  6. Looking for better Search Method Listbox VBA
    By kpnaish in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-14-2013, 12:01 PM
  7. Listbox Search Function
    By Brian C in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-13-2006, 03:10 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1