Application.Caller was exactly what I was looking for. Thank you all for
taking the time to answer my question.

/Jonas

"Bob Phillips" wrote:

What sort of checkboxes?

Forms Toolbar?

Select Case Application.Caller
Case "Check Box 1": MsgBox "Checkbox1"
Case "Check Box 2": MsgBox "Checkbox2"
Case "Check Box 3": MsgBox "Checkbox3"
End Select


--
HTH

Bob Phillips

"josa01" wrote in message
...
Hi!

I have multiple controls (checkboxes) that I've tied to the same macro
with
the OnAction property. How do I find out which control triggered the
macro. I
guess that I could dynamically add a unique version of the same macro to
all
the different controls, but I'd rather have one version of the macro work
for
all the controls.

Thanks,
Jonas