PDA

View Full Version : Checkbox onaction



redhunter
12-02-2012, 11:27 AM
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
12-02-2012, 12:39 PM
Try this
If TypeName(Application.Caller) = "String" Then
MsgBox Application.Caller & " was clicked" & vbCr & _
"Its value is " & (ActiveSheet.Shapes(Application.Caller).ControlFormat.Value = xlOn)
End If

redhunter
12-02-2012, 01:41 PM
excellent mike
thanks alot