Something like:

Option Explicit
Private Sub CommandButton1_Click()
If Me.CheckBox1.Value = True Then
MsgBox "It's checked"
Else
MsgBox "It's not checked"
End If
End Sub

Change the names to match your buttons and checkboxes.

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

--

Dave Peterson