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

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

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

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

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