I have a UserForm with multiple buttons backed up by code for each individual button as follows:
Code:
Private Sub Name_Click()
strName = "Name"
Call ModuleName.SubName(strName)
Unload Me
End Sub
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?