Hi Lisa,
Every control in Excel is an object to find the objects in excel sheet follow the below procedure
Go to Home –> Editing –> Find & Select –> Selection Pane.
- This will open a Selection Pane that will list all the objects on that worksheet (including checkboxes, shapes, and charts).
- The names of the checkboxes here are the backend names.
To get to status of check box
- Once you got your required object, write a VBO or macro to get the status of the object and trigger the same from Blueprism.
Sample macro:
Sub CheckboxValue_Method1()
Dim cbValue As Variant
cbValue = ActiveSheet.CheckBox1.Value
End Sub
Note: Replace CheckBox1 with your object name
------------------------------
Naga
Associate
Asia/Kolkata
------------------------------