Filter Listbox using textbox

[Fred Wayne]

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.

 

[AlanSidman]

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]

This is the original File of my project. I forgot to send it with the other files I sent before

 

[Fred Wayne]

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

 

[Belleke]

Hi Fred,
This is an easy one
In your code you have

With Sheets("Guests").ListObjects(1)

ListObjects(1) means a table but in your example you don't have a table.
Solution: insert a table in the guests sheet.
See attached.

 

[Fred Wayne]

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.

 

[Belleke]

how ashamed.

Don't be,we all have to learn.
Glad to help.

 

[Fred Wayne]

hello... is there a way to print a sheet from userform?

 

[Belleke]

Hello,
Yes there is , see attached.

 

[Sebastiandiaz]

THANKS SO MUCHHHHHHHHHHHHHHHHHHHHHHHHH... AMAZING. YOU´RE THE ONE. 2 THUMBS UP FOR YA!

 

[Sebastiandiaz]

I was searching and found this post...it was really useful for me. Thanks.

 

[navic]

Yes there is , see attached.

Can CheckBox be applied to hiding columns? I opened a new thread here on the forum.