topic RE: How to get checkboxes value in excel in Product Forum

How to get checkboxes value in excel

lisali — Wed, 18 Dec 2019 05:34:00 GMT

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

RE: How to get checkboxes value in excel

dmma — Wed, 18 Dec 2019 08:39:00 GMT

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

RE: How to get checkboxes value in excel

lisali — Wed, 18 Dec 2019 09:29:00 GMT

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

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

RE: How to get checkboxes value in excel

dmma — Wed, 18 Dec 2019 10:07:00 GMT

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

RE: How to get checkboxes value in excel

NagaM — Thu, 19 Dec 2019 04:39:00 GMT

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

RE: How to get checkboxes value in excel

lisali — Thu, 19 Dec 2019 05:45:00 GMT

However,thank you very much.

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

RE: How to get checkboxes value in excel

lisali — Thu, 19 Dec 2019 06:11:00 GMT

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

RE: How to get checkboxes value in excel

vivek.kumar.goel — Fri, 20 Dec 2019 03:59:00 GMT

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

RE: How to get checkboxes value in excel

lisali — Mon, 23 Dec 2019 00:56:00 GMT

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

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