Read checkbox value from Excel

[Neel1]

I am looking for solution on how can i read checked entry in excel worksheet.

sample entry in a column  looks like this. 




------------------------------
Neeraj Kumar
Technical Architect
------------------------------

[ManpreetKaur1]

Hi @Neeraj Kumar,

Did you try recording the macro while performing check/uncheck?

Using the code generated, you can capture the function which is changing its value and later on, use it for reading if the value is checked or not.​

------------------------------
Manpreet Kaur
Manager
Deloitte
------------------------------

[ThomasHutchins]

You can link each checkbox to a cell on the worksheet. Right-click on a checkbox and select Format Control... In the Cell link: box, assign a cell for that checkbox (maybe in an unused column on the same row). When the check box is clicked, the linked cell will contain TRUE if checked or FALSE if unchecked. The process can read the TRUE/FALSE value from the linked cell. It can also change the checkbox state by entering TRUE or FALSE in the linked cell.

The downside is having to link each checkbox individually.

------------------------------
Thomas Hutchins
Lead Developer
Discover
America/Chicago
------------------------------