How to get checkboxes value in excel

[lili]

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

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

 

[lili]

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.

 

[anuraag_msg]

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.

 

[Mikkora]

When creating instance (with Excel VBO), remember to set "enable events" input parameters as true. It will enables to run Macros.

 

[johnred]

Hi,
For example :
If UserForm1.CheckBox1.Value = True Then
MsgBox "Checkbox has Checked", , "Checkbox"
Else
MsgBox "Checkbox has Unchecked", , "Checkbox"
End If