Input Filtered DataBase into Userform Listbox by clicking cmd

Hello you all,

I need help to put a filtered database into a listbox on a userform by clicking on a button.

The button is "Mostrar Orçamentos" although it only shows the first column and without any headers.

I need to put that data into that userform with Headers and only the filtered ranges

I have a named range called "outdata" that i am putting on rowsource that is the usedrange

Hope you can help me out

Thanks

If anyone has any question let me know.

The Userform in doubt is "frmBaseDadosClientes"

Already managed to input the database filtered on the listbox, although it only allows me to do that if i fill ALL 3 CRITERIA COMBOBOX, if i only fill 1, 2 or none, it gets me an error of "object required"

Excel file is attached, Just click on the CMD button of "ENCOMENDAS" Then use the combobox's and above textbox to the criteria and test with the cmd, "mostrar Clientes"

Hope someone can help me out, putting this more flexible

Originally Posted by Leith Ross

Hello brainzip,

This version is radically different from your first post. At present, this is too large a project for to me. I simply can not devote the time needed to help you refine your code.

Hopefully, some other member in the forum has the time to help you with this.

Beir buaidh!
(Best of luck!)

Its not that different, and its almoço working as you can see. I just need some parte not the total Goa, just help me out with some like display the filtered data after criteria filter

Thanks you for your time

Can anyone give me some help or hints so i can put this working?

Thanks for your time