After you enter the macros the 1st time you need to click one of the check
boxes and save the file. After that it should work correctly. the macros
won't work until you click a box.

"James8309" wrote:

On Jun 6, 4:38 pm, Joel wrote:
Use these three click functions. Put them in the VBA sheet page where the
check boxes and button are located.

Private Sub CheckBox1_Click()
If ActiveSheet.CheckBox1 = True And _
ActiveSheet.CheckBox2 = True And _
ActiveSheet.CheckBox3 = True Then

ActiveSheet.CommandButton1.Enabled = True
Else
ActiveSheet.CommandButton1.Enabled = False
End If

End Sub
Private Sub CheckBox2_Click()
If ActiveSheet.CheckBox1 = True And _
ActiveSheet.CheckBox2 = True And _
ActiveSheet.CheckBox3 = True Then

ActiveSheet.CommandButton1.Enabled = True
Else
ActiveSheet.CommandButton1.Enabled = False
End If

End Sub
Private Sub CheckBox3_Click()
If ActiveSheet.CheckBox1 = True And _
ActiveSheet.CheckBox2 = True And _
ActiveSheet.CheckBox3 = True Then

ActiveSheet.CommandButton1.Enabled = True
Else
ActiveSheet.CommandButton1.Enabled = False
End If

End Sub



"James8309" wrote:
Hi Everyone,

I have an excel file and I run my macro by clicking on the 'Button'
that I created on the sheet.

i.e. Click 'Run' button on the sheet then it runs my macro

Is it possible for me to actually hook checkboxes and the run button?

e.g. If I have 3 check boxes, User must check those boxes before
running the macro.

is there any better way of doing this? maybe only when all checkboxes
are ticked my run button appears? or blocks otherwise? anything will
help.

I am trying to create this because even though I placed
"INSTRUCTIONS" people wouldn't follow the damn thing and just click
the run button.lol

thanks alot- Hide quoted text -

- Show quoted text -


Firstly Thank you so much for your help.

I have placed three check boxes and clicked "view code" for that
particular sheet where all my checkboxes and run button are located.
However when I click the 'run' button without checking any boxes, it
still does its job. Could you please advise what I did wrong? Do I
need to assign something with those check boxes? How do I activate
those private click subs?