Access Excel VBA Control

[Andrew Chan]

Dear All,

Do anyone know how to access excel check box control? I have several Check box control in a sheet, both of them are named at "Check Box 1".... "Check Box N", how can i check the check box by VBA program? Can anyone suggest someway to check the bulk of check box smartly?

Thank a lot who reply the post, any suggestion would be appreciated.

Best Regards
andrew

[antoka05]

Please can you tell if you use userform checkbox or the checkbox is in the sheet (and in this case where you selected it, in the Visual basic tooldbar or in module toolbar)?
Thanks.

Regards,
Antonio

[Andrew Chan]

the checkbox is in the worksheet, it is added by dropping from Excel->Form tool bar. Could you please help? thanks a lot.

[Andrew Chan]

i have recorded marco, it show the following code:

Please Login or Register  to view this content.

However, it is not work for second time running, it show that selection is nothing, what can i do now? thx a lot.

[antoka05]

You can try with this code but may exist another method to avoid to select each object:

Please Login or Register  to view this content.

Regards,
Antonio

[royUK]

i have recorded marco, it show the following code:

xlWS.Shapes("Check Box 1").Select

With Selection
.value = xlOn
.LinkedCell = ""
.Display3DShading = False
End With

However, it is not work for second time running, it show that selection is nothing, what can i do now? thx a lot.

Andrew please read the Forum Rules & use Code Tags in future.

[Andrew Chan]

Dear Antonio,

This code runs successfully, thank a lot.

Best Regards
andrew

[royUK]

Dear Antonio,

This code runs successfully, thank a lot.

Best Regards
andrew

Have you read the Forum Rules? An acknowledgement concerning myt previous post would be in order!

[Leith Ross]

Hello Andrew Chan,

Here is a simpler way. The Active Sheet contains a collection of the Forms Check Boxes in a collection object called CheckBoxes.

Please Login or Register  to view this content.

Sincerely,
Leith Ross