How to get checkboxes value in excel

[lisali]

Hi all,
How to get checkboxes value and their location in excel ?

I tried MS Excel VBO::Get Worksheet As Collection,but get noting.

------------------------------
lisa li
------------------------------

[dmma]

Hi Lisa, 
In think you won't be able to get checkbox value, but you can make a workaround.

You can try and create linked cell to this checkbox. 

Check this link: How to make checkbox checked based on cell value in Excel?

Extendoffice		remove preview
How to make checkbox checked based on cell value in Excel? You may know how to change a cell value based on a checkbox. But, do you know how to make a checkbox checked automatically based on a cell value in Excel? This article will show you methods to achieve it. View this on Extendoffice >

 
Or 
Use Check Box Result in Excel Formula - Contextures Blog

Contextures Blog		remove preview
Use Check Box Result in Excel Formula - Contextures Blog To make it easy for people to enter data on a worksheet, you can insert a check box control, using the Form Control tools on the Developer Tab. Then, use check box result in Excel formula solutions. Form Controls on Developer Tab If you don't see a Developer tab, there are instructions here for showing ... View this on Contextures Blog >

Hope it helps.


------------------------------
Kind regards,

Dmitrij Mamajev
RPA Developer
Volvo Cars
Gothenburg - Sweden
------------------------------

[lisali]

Thank you very much for your answer, @dmma
But I want to get it by blueprism. Do you have any other way​s

------------------------------
lisa li
------------------------------

[dmma]

Another way is to use Region modes. But it might become complicated.

So its up to you!

------------------------------
Kind regards,

Dmitrij Mamajev
RPA Developer
Volvo Cars
Gothenburg - Sweden
------------------------------

[NagaM]

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
------------------------------

[lisali]

However,thank you very much.

------------------------------
lisa li
------------------------------

[lisali]

Thank you very much for your answer, Naga​​
I writed a  macro to get the status of the checkbox.But I encountered a little problem when running it on blueprism.

My macro name PERSONAL.XLSB!CheckBox.I can manually execute it successfully.

But I got an error reminder when I run the Run Macro via blueprism.

error  message:The code stage could not be executed because an exception was thrown by the code stage. The macro '' PERSONAL.XLSB! 'CheckBox' cannot be executed. Macros may not be available in this workbook, or all macros may be disabled.
Can you help me

​

------------------------------
lisa li
------------------------------

[VivekGoel]

2 Options:

1- Either Change the macroname to be a simple name without special characters
2- Just pass the name as it is "PERSONAL.XLSB!CheckBox" nothing else.

------------------------------
Vivek Goel
RPA Architect
Asia/Singapore
https://www.rpatools.com/
"If you like this post, please press the "Recommend" Button.
------------------------------

[lisali]

Thank you very much for your answer.
I solved the problem.


------------------------------
lisa li
------------------------------