cascading combo boxes to run loop

hello everyone,

I have a userform with three cascading combo boxes. the goal of the userform is to be able utllize the data that is selected in the cascading combo boxes and loop all the data/transfer the data onto a new worksheet. The first combo box selects the specific document the user wants, the second combo box selects the date of the document and the third combo box selects the date the data was inputted into the datasheet/database. The dilemma that I'm currently having is I am unable to run the loop based on the criteria of my combo boxes. I was able to run the loop based on the selection of the Document combo box by itself, but was unable to incorporate the other two combo boxes. your help would be greatly appreciated.

Thanks, unioncascading loop.xlsb

hello jindon, my deepest apologies, I'm very thankful that you helped me out on the previous post. I am very sorry that I didn't get reply back to your post because I was busy at work. I'm still new to these user forums. I'm assuming it is considered good etiqutte to reply back to one's post.

If you find that the code I posted have solved your problem, please mark that thread in the link as "Solved".

Password in the attachment removed.

greatly appreciate the help jindon. i got two more questions to ask you. I was messing around with it last night and i realized another solution to my problem. it was actually a quick fix, but i realized that i needed to mess with the formats of the dates. so i used cdate(ws.cells(x,1))=me.combobox2.value e.g "date of doc" and also the samething for its dependent combo box e.g. "Date of input" and I was also able to successfully the loop. I also noticed how you write your code is completely different from how/what i have been learning so far with my current resources. But if you don't mind me asking is the way how you write code more efficient or superior? or is that just how you learned? because to be honest i was quite confused on what you wrote to initialize the user form. p.s. I'm still a noob