• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Filter Listbox using textbox

Fred Wayne

New Member
Hello. My name is Fred. I am making a little project for my University. I am making a file in which I have several sheets. One of those sheets is called "Guests", I need to make an UserForm with a ListBox in which all guests names will be displayed(Guests names are in "Guests" Sheet.) I have created a TextBox and I need to search guest names from that textbox. All the Sheets have a button to display the "Guests UserForm", but when I try to open it, an error of "Run-Time error '9': Subscript Out of range" is displayed. A made a macro to search from the same guests sheets but it makes my workbook kind of slow. Would you please help me with this. I have tried on different ways to make it filter from "Guests" sheet but it has been so hard for me to get it. I would love you to help me on this. In the "Guests" UserForm you will find the code I used to make the textbox filtering. I will attach some screenshots and the original file. On a past forum I requested for your help, and you did help me and you fixed a file I sent. but I had to open a new post. I´d really love you to help me finding out why i can´t get it. YOU ARE THE BEST. THANK YOU VERY MUCH.
 

Attachments

AlanSidman

Active Member
Pictures
Hi and welcome to the forum

Pictures are of little value. Honestly, no one wants to re-type your data to try and solve your issue. Additionally, we would only be guessing at how your data was structured, ie. formulas, formatting, etc. Additionally, due to how some browsers behave, many of our members cannot see uploaded pictures/images. Please do not take this route.

Please attach a sample file that represents what you have. The structure of your attachment should be the same structure as your actual data. Any proprietary information should be changed.

Include in the attachment any code you're currently using (whether it works or not) and an "After" of what you wish the output to be.
 

Fred Wayne

New Member
The file I have just sent, it´s a file that I make some days ago and you helped me to get the code to filter information in the ListBox from the TextBox
 

Attachments

Fred Wayne

New Member
Wow amazing. I don´t have words to express how ashamed. I never imagined it was that simple issue. Thank you so much. I was so tired that I never realized about the table. You are the best.
 
Top