Sunday 2 August 2020

Display Search results in ListBox with more than 10 Column ( 17 Column ) in excel VBA ||


Click Here to View VBA Code and download this file.


11 comments:

  1. can you share the file? what is search data sheet content?

    ReplyDelete
  2. When I try to do the same thing, it says that access denied... perhaps sometihng with "With userfom1"? Cos I have renamed it ?

    ReplyDelete
    Replies
    1. Please send me your email directly or through contact form
      Thank you

      Delete
  3. sir,
    very useful creation. if i want to add 'to' and 'from' dates in this module how to coding. pls.advise.

    ReplyDelete
    Replies
    1. https://youtu.be/MRNcYoFtYBg

      You can visit the above video. I hope you will find your answer

      Delete
  4. Thank you for this video post. I will try to learn something out of this. This video is helpful but my project is little bigger.

    Three List boxes. 1. Customer name, 2. Website 3. Country ( based on Regions)
    1 combo box with regions ( Asia, EMEA, America)
    1 List box


    I am doing one project based on this. However, my search box one is "Customer Name", second is "website", third combo box 3 Regions, 4th is again search box "Country Name" and final the list box filter.


    if one search with only customer name listbox will show filter data,
    if one search with website listbox will show filter data

    Or either or.

    more filter that customer name will be search then Region like America is filter from combo box and if country will given then the filter will drill down to only customer which is in America Region in particular country.

    If you got my point then help me to move ahead..

    ReplyDelete
  5. Please send this file

    ReplyDelete
  6. hello, can you please send me a copy of this file? thank you

    ReplyDelete
  7. Very aptly made this file. It is helpful for formulating a project for myself. Thanks for the effort and to publish this.

    ReplyDelete
  8. Excellent article and this helps to enhance your knowledge regarding new things. Waiting for more updates.
    Advantages of Angular JS
    Benefits of Angularjs

    ReplyDelete
  9. Hello, I copied this file into mine but slightly different, now I want to have it for my database but always get the message variable not defined when I add the following Private Sub UserForm_Initialize() How shall I do this? please let me know if you know the answer or email me nickrubingh@live.nl

    ReplyDelete