Way to get Excel check box form value

Help
1

Hi all,

I have a question how to get check box value in Excel that is created by Excel Form item like this.
Sample.xlsx (18.1 KB)

I know one way that using Macro (checkboxName.value) but I found those check box name can be duplicated and I think that is unreliable way to do it…

If anybody have good idea, please share with me.
Thanks in advance,
J,

2

Hi @Jumbo,

Did you find any help? I am facing similar issue. Any help would be appreciated !

3

@Devi_Raji

I think macro is the only way to get a check box value except OCR… you need try invoke macro with checkboxName.value, it will return number and you can identify true or false.

J,