MachuPichu92
New Member
- Joined
- Feb 4, 2020
- Messages
- 15
- Office Version
- 2016
- Platform
- Windows
Hi everyone,
I almost finished my macro that automatically sends emails to different companies. Sometimes, I don't need to send emails to all companies included in the macro, but only to few.
I was thinking about an userform containing multiple checkboxes holding company name and SEND button. Click on SEND buttton would execute only those parts of macro that include chosen partner from ticked checkbox. Be aware that I have only one Sub.
Do you have any suggestions on how to define which part of code should be executed when checkbox is ticked?
I hope I described my issue understandable and thanks for you answers.
I almost finished my macro that automatically sends emails to different companies. Sometimes, I don't need to send emails to all companies included in the macro, but only to few.
I was thinking about an userform containing multiple checkboxes holding company name and SEND button. Click on SEND buttton would execute only those parts of macro that include chosen partner from ticked checkbox. Be aware that I have only one Sub.
Do you have any suggestions on how to define which part of code should be executed when checkbox is ticked?
I hope I described my issue understandable and thanks for you answers.