Excel use Checkbox in vba

Question

I need to verify if an activex checkbox is checked in my vba code, however, when I try - " If Checkbox1.Value = True Then" it is asking for variable not defined. What am i missing?

Is your checkbox named CheckBox1? How about Sheet1.CheckBox? Is it an activeX checkbox, or a form control checkbox? — JNevill
– JNevill, Commented Jun 29, 2016 at 19:06
ActiveX control and I tried sheet("BalanceSheet").checkbox1. Still having issue. It also is the activesheet. — Karen Schaefer
– Karen Schaefer, Commented Jun 29, 2016 at 19:08
And you are certain it's named Checkbox1? Other than that, I don't see anything wrong with the code. — JNevill
– JNevill, Commented Jun 29, 2016 at 19:12

Gary's Student · Accepted Answer · 2016-06-29 19:12:51Z

2

How about:

Sub dural()
    If ActiveSheet.OLEObjects("CheckBox1").Object.Value = True Then
        MsgBox "it is checked"
    End If
End Sub

Note this is for a "standalone" ActiveX checkbox (not on a userform)

answered Jun 29, 2016 at 19:12

Gary's Student

96.9k10 gold badges66 silver badges104 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Paul Roub · Accepted Answer · 2016-07-02 20:20:25Z

-1

Try:

If Me.Checkbox1 = True Then
  'whatever code goes here
End If

edited Jul 2, 2016 at 20:20

Paul Roub

36.5k27 gold badges88 silver badges95 bronze badges

answered Jun 29, 2016 at 19:06

JB28

571 silver badge10 bronze badges

3 Comments

Karen Schaefer Over a year ago

this is Excel not access vba - I believe I need to pass the sheet name...

JNevill Over a year ago

Me is fine to use in Excel VBA, however, it's superfluous in this instance. If this code is in the worksheet's vba code, then it will work. If the code is in a module, then me would be referencing the module.

JB28 Over a year ago

Did you look at this forum at all? - mrexcel.com/forum/excel-questions/…

Collectives™ on Stack Overflow

Excel use Checkbox in vba

2 Answers 2

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related