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
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
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]
excellent mike
thanks alot