Find Data in Form

[marreco]

Hello everyone, I would like to do a search based on two criteria, then post this data in the ListView.

I am TxtBox1 = start date.
TxtBox2 = end date.
these data will be sought in sheet1 column A7.
In a Listbox, will put the user in this case which will get users on Sheet2.

Caaso find the dates entered in txtbox1 and 2, and search for the Junior Member lilstbox, then what is found will be shown in the ListView.

See my attachment, he already has the form ready.

Thank you!

[Charles]

Hi,

Here's a bit of code that can help you get started. It will filted for the Dates in Textbox1 and 2. All you need to do is provide the code to populate the Listview.

Please Login or Register  to view this content.

[marreco]

Thanks for responding but still could not adapt.
Now how do I load the lisview with the code you sent me?

Thank you

[royUK]

Why do you need a ListView, a ListBox would be simpler & looks to me to be better suited

[marreco]

Since, show me the result of the data in column A to column K.

For me no problem.

Thank you!

[royUK]

Since, show me the result of the data in column A to column K.

For me no problem.

Thank you!

It's obviously a problem because you are asking the question. A ListBox will do thiis with less programming

[marreco]

Can you help me?

Thank you

[marreco]

Hi..

Any Idea?
Thank you

[jaslake]

Hi marreco
I'll be glad to look at this with you. The file you attached has an invalid digital signature and so, won't allow Macros to run. Please remove the digital signature and upload the file again.

[marreco]

Forgive me master jaslake.

See if it's right now.

[jaslake]

Much better

[jaslake]

Hi marreco
Attached is a file that has ListView Controls embedded. It appears to gather the data you requested. Some error checking needs to be incorporated but, now that you have it, what are you going to do with it?

[marreco]

Good morning!
I have not done any more testing I'm very happy.

It was perfect, you're a genius excel, thank you very much!

Will I ever know what you Excel and VBA?

[jaslake]

Hi marreco
Happy to have helped...thanks for the style points. Regarding this

Will I ever know what you Excel and VBA?

I don't have it figured out yet...perhaps we'll do it together.

[marreco]

I'm trying to make an adjustment in your code to another arquuivo.

But I'm not consguindo.
http://www.excelforum.com/excel-prog...-combobox.html
If you have some time and can look, anyway thanks!

[jaslake]

Hi marreco
My Portuguese/Spanish experience is about 60 years in the past (I'm an old guy). I looked up arquuivo and it seems to mean file (which, in context, makes sense). Couldn't find consguindo but I assume it means "I don't understand". I've subscribed to your new Thread...I'll follow it and respond as I can.

[marreco]

I am very happy, thank you!

Arquivo = File
Português English