I have a UserForm with multiple buttons backed up by code for each individual button as follows:
where Name changes for each button. Rather than hardcoding strName = "Name" I would like to reference the name of the module and truncate the _Click() portion of the module name to then get the function for my strName definition. Is this something that is possible within VBA?Private Sub Name_Click() strName = "Name" Call Module.Sub(strName) Unload Me End Sub