A VBA code that clicks a checkbox

N

nevaspb

Having some difficulty with VBA code. Any help is appreciated...
What I am trying to do is to have an "IF" command that would
CHECK a checkbox in excel if a certain cell has a certain text in it,
i.e.

Sub Click_Me()
If "A12" = "Mortgage" Then CheckBox10_Click = True
End Sub

What am I doing wrong?

Thank you very much in advance.
 
D

DavidC

Try this

Sub Click_Me()
a = CheckBox10
If ActiveSheet.Range("A130").Value = "Mortgage" Then
ActiveSheet.CheckBox10.Value = True
Else
ActiveSheet.CheckBox10.Value = False

End If

End Sub

You can see the differences. Basically each cell has to
have a value assigned.

BOL

DavidC
 
B

Bob Kilmer

As for what you are doing wrong, CheckBox10_Click is an event handler (a
procedure that executes when an event occurs). It is not something you can
assign a value to. If you wanted your code to execute the same code that a
mouse click would execute, you can call the event handler like any procedure
(but this would NOT change the state of the checkbox, as an actual mouse
click would).

Sub Click_Me()
If "A12" = "Mortgage" Then CheckBox10_Click
End Sub
 
Top