Calling a checkbox_click from VBA

[bbhgroup]

I have a checkbox subroutine Checkbox4_Click() that works when clicked on the spreadsheet. I want to call this same function inline from VBA but I can't seem to get the syntax right.

Any help?

 

[texasalynn]

so what have you tried?

I've used in VBA something like this:
If CheckBox3 = False And CheckBox4 = False Then
MsgBox "The select option for FRF was not checked"

 

[bbhgroup]

I've been using the object browser to try and figure it out. So far I have:

VBAProject.Sheet1.CheckBox4_Click (VBAProject.Sheet1.CheckBox4.Value)

but I get a "compile error' and the "CheckBox4_Click" is highlighted.

Ah, I figured it out.
First I had to change the CheckBox4_Click to be a public sub.
Then I changed to code to:

VBAProject.Sheet1.CheckBox4_Click

Since no arguments are necessary!