Excel based scenario

[Ashwinny_Ls]

Hi Friends,
How to check the check box is checked or not in excel.
Someone please help me on this

[pavithra_pavi (Pavithra Bhat)]

Hi @Ashwinny_Ls ,

As per my knowledge, to check if checkbox is checked or not you can use GetText
. and based on the output value, you can identify if it is checked or not.

There is a activity called Check

Here, there are 3 option at Action properties : Check, uncheck and toggle
https://docs.uipath.com/activities/docs/n-check

[Jobin_Joy]

Hi @Ashwinny_Ls

You can refer the below posts are well.

Click checkbox in excel file

Haha okay next quetion: I have the below code that im invoking: ActiveSheet.Shapes.Range(Array(“Check Box 1”)).Select With Selection .Value = xlOn .LinkedCell = “” .Display3DShading = False End With End Sub How do I change the 1 in “Check Box 1” with a variable that I want to pass in from Uipath? Is this possible?

How to know check box is checked or not in excel

how to know checkbox is checked or not in excel [CaptureForCheckBox]

Invoking VBA to achieve this.

Hope this will be helpful. Thank you.

[Ashwinny_Ls]

Can you plz tell me the steps

[arivu96 (Arivazhagan A)]

Hi @Ashwinny_Ls ,
Try macro to check the check box is checked or not.
Refer below existing link

How to know check box is checked or not in excel

Hi @sithulinhtut, Please find the below methods. Method1: Using Macro. Please check the below link. You can write a Macro and use Invoke Macro Activity to implement it. Macro to Read Checkbox Method2: Use Image Exist Activity.

Regards,
Arivu