Tick a specific checkbox base upon the value of another cell

[cyberburn]

I recently converted a physical form that students are required to fill out by hand into a web based form. The data is subsequently exported to an Excel spreadsheet. From there I want to transfer the data to a report that will be printed out and placed in the students file. The format of the report will look identical to the physical form and includes checkboxes. My challenge is to write a code that selects a specific checkbox based upon the value in the cell of the exported spreadsheet. For example, one question students are asked is "Are you a veteran?" to which they either answer "Yes" or "No". Based on their response I would like to tick either the "Yes" checkbox or "No" checkbox in the report.

So far I have only found posts showing how to select/deselect all checkboxes in a sheet or range but not how to select a specific one. Any help would be appreciated. Thanks!

[Leith Ross]

Hello cyberburn,

Welcome to the Forum!

It would be a great help if you posted the workbook. It will save time and get you a working answer faster.

Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show your desired results.

Please redact or change any information that is confidential, personal, or sensitive in nature before you post your workbook.

To Attach a File:
1. Scroll down to the window below your post Additional Options
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

[AlphaFrog]

Based on a Yes\No value in Sheet1 A1, this will check either Check Box 1 or Check Box 2 on Sheet2.

This presumes your check boxes are Form-Type check boxes and not ActiveX-type check boxes.

Please Login or Register  to view this content.

[cyberburn]

Thanks AlphaFrog! That did the trick. To follow up, I initially renamed the checkboxes (and code to match) but when I ran the macro I got the error "Unable to get the CheckBoxes property of the worksheet class". However when I changed them back to the default names it worked fine. Must default names be used? Doesn't make much sense if they do. thanks again.

[AlphaFrog]

You're welcome.

The default names do not have to be used. My first guess is you didn't have the check box names or sheet name in the code exactly the same as the changed names.