[Excel 2007 & 2003, WinXP SP2]
I have several class modules that are used to control groups of similar
controls. I also have several forms which have some similar controls,
and I have created different class modules for each form.
Is there a way to identify which form has triggered the class module,
and use that as a variable in the class module?
Here's an example of some code in one of my spinbutton class modules:
can I identify the form that triggered the event, and use that as a
variable to replace "frmStatistics" ?

Private Sub StatSpinGroup_SpinUp()
Dim strName As String
Dim iStat As Integer
strName = "txt" & Replace(StatSpinGroup.Name, "spn", "")
iStat = Val(frmStatistics.Controls(strName).Text)
frmStatistics.Controls(strName).Text = iStat + 1
End Sub


Thanks.
Darren