topic RE: Read checkbox value from Excel in Product Forum

Read checkbox value from Excel

Neel1 — Thu, 15 Sep 2022 08:52:00 GMT

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

RE: Read checkbox value from Excel

ManpreetKaur1 — Thu, 15 Sep 2022 10:42:00 GMT

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

RE: Read checkbox value from Excel

ThomasHutchins — Thu, 15 Sep 2022 14:39:00 GMT

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