I have a workbook where users select a specific type of notification email they want to create and send out. There are 8 different types of notifications that open different userforms (which all ask different questions, etc...). The one thing they have is common is a group of checkboxes with the same name that open another userform where the user can select the email groups they want the notification sent to.
After they've selected the groups they want to email and hit OK to close out of the email userform, I want to update the checkbox caption on the notification userform to display how many groups were selected. I really don't want to update the caption on all 8 userforms and instead would just like to update the caption on the userform that initiated the action.
I thought I could do this by storing the userform name in a variable (frmName) and then reference the variable and the checkbox... something like frmName.chk2.caption = "something". My variable is currently Public and stored in a module. I've tried different types like object, userform, string, etc... but I just bounce between various errors and can't seem to figure this out.
Bookmarks