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.
Hi,
For example :
If UserForm1.CheckBox1.Value = True Then
MsgBox "Checkbox has Checked", , "Checkbox"
Else
MsgBox "Checkbox has Unchecked", , "Checkbox"
End If
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.