Can a Userform Combo Box selection run a macro based on the selections filtered criteria?

Hello everyone, I have a question as to if the below scenario is possible.

In my workbook, my data is stored on sheet “Main”, and I would like to know if it is possible to create the following code to run in a userform of excel:

I would like all rows from sheet “Main”, that contain a value of “X” in column D to run an excel to word export macro individually. Each row contains data that will relate to a bookmark on a word export template file (docx). I already have a few template macros (that I've found on here!) that I will be able to tweak when the time comes... in order to manage my data export.

As an example, if there were 15 rows of data that contained value “X” (from column D), the macro would have ran 15 times and 15 separate word documents would generate as a result.

NOTE: The operation itself will be executed by a user form. “X” Value will be chosen by a Userform combo box, and a command button will start the macros once clicked. Also note “X”=ticket number i.e. “13-QA-000”.

Is something like this possible?

In summary: Userform combo box selection filters “Main” data for all data related to selection of “column D” i.e “X”. User presses a button that runs a macro for each row of data related to value “X”.
This is my first time posting on here, so I would like to apologize if I didn’t follow any forum guidelines.

Thanks all in advance!!!

Thanks so much for the quick response!

I briefly tried your code and it seems to work for my needs, I can't believe how easy you made that seem. I will need to finish my new export macro and new template to put it to the true test. I'm still not sure if the code will run the macro multiple times based on number of rows that equal my combo selection? I will post after I validate the operation...

Thanks again,

You are correct. I only had test data in my workbook so I added two(2) lines of data with the same ticket number and it did call the macro 2x's! Very awesome.

This may require a new thread, please advice if so...

How will I get that separate data for each word popup to fill in the info for that line?

As an example: I select 13-QA-001 (Lets say it has 3 alike rows) press the button--> it generates the first row of data into the word template putting in the correct data per that row of data.-->generates another putting in the data, but that data is different then the first one generated, only thing alike is the ticket number (qty. batch number. date fields are different).--> same thing for the third form...

Would that be hard to acomplish? Would I need to detail the code in the excel to word macro vba?

Thanks,

Ok. I will try this tomorrow. Thanks

I've attached an example of the word macro. It will be much larger than this when I create it specifically for this form, but I was wondering if you could explain how I would "pass the row number (I) to that macro and then it could use that to retrieve the relevant qty, batch number etc."

This is the macro (an example-actual will have more bookmarks, etc...) that runs after the user selects the ticket number and presses the button...

Please Login or Register  to view this content.

Thanks, I appreciate all the assistance thus far,

This worked perfectly! I created my new form and the macro to go along with it. Next thing I will be doing is studying what we have done here so I can actually understand why you did what you did... which made this work.

I can't thank you enough for your help, you saved me hours of searching other forum posts!

this issue is solved. (not sure how to mark this thread as solved?)


Hope you have a great weekend, Thanks,