How to read values of checkbox in Excel?

I have an Excel file and it has Checkboxes in a certain column. I need to know the value of each Checkbox under this column. Since this Excel file has a bit data table, I am going to use Read Range.

It seems like this Checkbox is made from Developer Tab > Insert > Checkbox.

When I just used Read Range, it returns a blank/empty string, and I cannot get the value of whether there is a check or not.
How can I do this with Read Range?

I found some documents for similar questions, but they are all talking about checkboxes in Word. Mine is specifically for Excel.

Sample Excel file:
Checkbox.xlsx (12.4 KB)

2 Likes

Can you share the file?

Any excel file with CheckBox is fine. I added a file to my question.

There is a different thread concerning this problem, using some invoked VBA code (How to get the value of checkboxes in excel table - #2 by Nithinkrishna).

I am currently also facing this problem, where a larger number of checkboxes is placed on each row in a specific column (8 checkboxes in one cell). How would I be able to retrieve the data (True/False for each 8 checkboxes), for each row?

Is there anyone who could help me with this?

Hey @Roderick_Tam

Did the solution helped ?

Thanks
#nK

Well, for a single checkbox in a row, yes. But not for multiple checkboxes laid in one cell. And I am looking for a solution for that.

Something similar like this:
image

However, there are 8 checkboxes per cell.

I noticed in your VBA code snippet, that the checkboxes are indexed by the instance of a checkbox, not row number right? So think that if there are multiple checkboxes, the checkboxes will be: (Row 2: Car = 1, House = 2, Pet = 3, Row 3: Car = 4, House = 5, Pet = 6). Is this unavoidable or can we connect the cell or row number with the checkbox instances?

1 Like

Hey @Roderick_Tam

A small update on the existing code should do trick !

You can check that meanwhile I can try to provide you as well and if possible please share the sheet here.

Thanks
#nK