find textbox value in sheets and put all matching criteria in a listbox

Excuse me, I'm having a problem with this vba
I'm new in vba for excel and I want to make a program which I can input data using userform and then search the data by using other form (I make 4 different userform). All the data is in one sheet, and the search criteria that I want to find is in column B.
My problem is I can't make find code yet.
I try to copy some code (just in search code) from excel-it.com database but I'm having trouble since it said that "object variabel or with block variable not set"

Would you please tell me what is wrong with my code

Please Login or Register  to view this content.

Thanks before

With block variable is MyData (a range) which is declared as a Range but not defined. Set MyData to let the code know that what is range MyData.

If you can provide a sample spreadsheet..
May be then we can provide you a better code..

Hi, edwinsihaloho,

the origional concept only had one UserForm (I canīt see the reason for more than one), if you use more than one userform make sure to fully qualify your controls with the name of the userform as well.

@sktneer:
in the original coding MyRange is set in UserForm_Initialize.

Ciao,
Holger

Hi, edwinsihaloho,

I doubt itīs a good idea to attach a macrofree workbook without the userforms and the code when you are asking a question about VBA.

Ciao,
Holger

Hi, edwinsihaloho,

you should copy the codes as they are listed.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Ciao,
Holger