Checkbox onaction

[redhunter]

Hey folks

Have lot of CheckBox'es (formular-menu)
Created with a macro and all with onAction="test"

Now i vant the macro "test" to tell me the name of the CheckBox
that was clicked

Haw ???

tanks in advance

[mikerickson]

Try this
[VBA]If TypeName(Application.Caller) = "String" Then
MsgBox Application.Caller & " was clicked" & vbCr & _
"Its value is " & (ActiveSheet.Shapes(Application.Caller).ControlFormat.Value = xlOn)
End If[/VBA]

[redhunter]

excellent mike
thanks alot