Hi Norman,
I tried your solution and it worked fine. I also then tried to do
the same from a vba form to get the same chkbox but instead of Me I
used with ActiveSheet and it worked fine too.

Thanks for the idea,

Sterl
Norman Jones wrote:
Hi Sterl,

Try something like:

'=============
Private Sub CommandButton1_Click()
With Me.CheckBox1
.Value = Not .Value
End With
End Sub
'<<=============


---
Regards,
Norman



"Sterl" wrote in message
ups.com...
Hi,
I have a vba command button and checkbox on an excel spreadsheet.
How can I reference the chkbox from the click event of the command
button. I would like to turn it on and off from the click event of the
command button.

Both are from the vba toolbox and both are directly on the
spreadsheet and not on a vb form.

I don't know if this is possible but if it is it would be very helpful
to me

thanks'

Sterl