Hi Dave,
Your suggestion worked fine...didn't know about the Me...I'm a bit
new at this.
thanks,
Sterl
Sterl wrote:
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