Search in UserForm and Display in ListBox

[jaylyn_cpa]

Good day, i am new in VBA and i want to start a new VBA project.
what i wish to do is a userform with search button and display multiple result in listbox.
i dont know where to start. i tried using Instr function but still i am no good
please help me.
thanks

[dotchiejack]

See example.
It works with table called data_tbl
The 2 textboxes are called T_00 and T_01
The Listbox is called LB_00
Articles that do not meet the search criteria will be removed from the list.
If you have difficulties post a small example of your file.

[jaylyn_cpa]

Here is my sample data. thanks

[dotchiejack]

What do you want to search, Name?

[jaylyn_cpa]

I want to search for name.
Thank you very much for assistance

[dotchiejack]

Search the name, click in the list on the correct name.
You can fill the searchsheet with the result.

[jindon]

jaylyn_cpa

Do you need a CommadButton???

Please Login or Register  to view this content.

[torachan]

Hi.
Try the attached, I have replace your textbox with a combobox.
This is populated with uniques from your 'register'
The 'register' is now in 'table' format as this expands your updating of the combobox is automatic.
torachan.

[jaylyn_cpa]

hello, thank you for this but there is a little problem, when i search on search box, date in listbox is not appearing.
Attachment 647222

[jaylyn_cpa]

Search the name, click in the list on the correct name.
You can fill the searchsheet with the result.

Sir when i search and click, date is not shown. thanks

[jaylyn_cpa]

Hi.
Try the attached, I have replace your textbox with a combobox.
This is populated with uniques from your 'register'
The 'register' is now in 'table' format as this expands your updating of the combobox is automatic.
torachan.

Thank you for this.

[jaylyn_cpa]

jaylyn_cpa

Do you need a CommadButton???

Please Login or Register  to view this content.

Thanks for this, im gonna use it for reference