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