VBA UserForm: Filter data in between dates using sheet name (FYI: i have multiple sheets, around 20-30 of them)

[wcanarejo]

Hi everyone,

I am new to Excel VBA, and I have some issues filtering data in between dates.
I Just want to be able to filter entries (from date-to date) using the sheetname as a criteria.

This is how the form look like( please see attached photo)


Or if you have any way get this sorted out, please do suggest. I really need your help.
Thank you very much

 

[wcanarejo]

YAY!!!! works like a Charm!!!! Thank you so much Sir!

 

[mumps]

You are very welcome.

 

[wcanarejo]

You are very welcome.

I'm sorry but I want to ask your for another thing, if it is okay with you.
Can you tell me how to print the listbox content after filtering. Thank you so much.

 

[mumps]

Try inserting this line of code:

.Parent.PrintOut

immediately below this line:

.Range("A1").CurrentRegion.AutoFilter Field:=1, Criteria1:=">=" & CLng(beginDate), Operator:=xlAnd, Criteria2:="<=" & CLng(endDate)

 

[wcanarejo]

Yes, that did print right away. Thank you sir. I cant thank you enough

 

[mumps]

My pleasure.