How to reference a vba chkbox from a vba command button on excel?

[Sterl]

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]

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.

 

[Norman Jones]

Hi Sterl,

Try something like:

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

 

[Sterl]

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