Checkbox in macros

[patricia75]

Hi, How do I get my macro to check a checkbox after certain tasks were done ?? Thanks

 

[VoG]

Where is this checkbox - on a sheet or userform. Is it an ActiveX control (i.e. how did you add it)

 

[patricia75]

Hi peter,
Checkbox is on a sheet. I just inserted it through "developper/insert". I would like the user to be able to follow the differents steps by having the macros clicking the checkbox each time a step is done . Thanks

 

[VoG]

Maybe like this (in the combobox code module)

Sub CheckChk()
Dim myBox As OLEObject
For Each myBox In ActiveSheet.OLEObjects
    If TypeName(myBox.Object) = "CheckBox" Then
        If myBox.Object Then
        '
        'your code goes here
        '
    End If
Next myBox
End Sub

 

[patricia75]

Thanks a lot Peter !