Hello Excel Forum members,
Greetings!
I have one scenario where I need some guideline based on your expertise
How do I pass list of items that are selected from a list box Critical-High Issues, UTT ISSUES, BTT ISSUES
(the list includes worksheet tabs with specific names, for example Critical-High Issues, UTT ISSUES, BTT ISSUES etc..)
when user clicked on a command button(Include) in userform(usrFrmemail) the selected only list items(if I select Critical-High Issues, UTT ISSUES as list items whichare required to pass to proc in other module.
I have a module based procedure where I am preparing a dynamic workbook with subset of tabs (few tabs / all tabs) such as selected tabs from listbox.
In a module I have following line of code where a new sub workbook is prepared dynamically but dependent on passed selected list items.
Please let me know, any help is appreciated.
attaching the template for reference on source code.
Regards,
Mahendra
Bookmarks