Greetings to all you señor Excels!
I have an Excel sheet that has approximately 25 columns and a continuously growing number of rows as it serves as a simple database.
What I'm trying to achieve is to have a Form Control button which upon pressing would pop up a window (user form) that would have all the column headings listed, and the user could easily mark with check boxes or similar all the columns he or she would want to include to the report.
The macro would then paste the selected columns to an already created worksheet for printout. In case it matters, filters are being used to sort data in the database, so at the time the user selects the columns for the report, there usually is a bunch of hidden rows in the worksheet (that are not to be included to the report).
I would really appreciate it if someone would be kind enough to help me with this case? I'm fairly inexperienced with VBA, but I know some basics and I am able to do some minor modifications to the code. I tried searching for similar cases from this forum but to no avail.
I have an Excel sheet that has approximately 25 columns and a continuously growing number of rows as it serves as a simple database.
What I'm trying to achieve is to have a Form Control button which upon pressing would pop up a window (user form) that would have all the column headings listed, and the user could easily mark with check boxes or similar all the columns he or she would want to include to the report.
The macro would then paste the selected columns to an already created worksheet for printout. In case it matters, filters are being used to sort data in the database, so at the time the user selects the columns for the report, there usually is a bunch of hidden rows in the worksheet (that are not to be included to the report).
I would really appreciate it if someone would be kind enough to help me with this case? I'm fairly inexperienced with VBA, but I know some basics and I am able to do some minor modifications to the code. I tried searching for similar cases from this forum but to no avail.
Last edited:
