VBA & Macro Problems

Fix Excel VBA Checkbox Values Missing When Emailing a Form

WPS Editor Oct 7, 2026 871 views

Question details

The user needs to email an Excel form containing ActiveX checkboxes, but the sent email displays True/False text values instead of the visual checked/unchecked boxes.

How to Fix Excel VBA Checkbox Values Missing When Emailing Forms

Product: Microsoft Excel
Device & OS: not provided
Scenario: Sending an Excel cell range containing a form via email using a VBA macro.
Observed behavior: The visual appearance of the ActiveX checkboxes is lost in the email body, and the linked cells only show textual boolean values (True or False).

Before you start

Before applying these VBA workarounds, ensure your Excel environment has Developer tools and Macros enabled, and save a backup copy of your original form.

Solution 1Recommended

Replace Checkbox States with Unicode Symbols via VBA

Use a VBA script to read the state of each ActiveX checkbox and output a visual Unicode symbol (☑ or ☐) into a regular worksheet cell before emailing the range.

Emailing a cell range converts the selection to basic HTML, which strips out interactive ActiveX controls. To maintain a visual representation of the form, you can translate the True/False values into text-based symbols that render perfectly in any email client.

Add a dedicated column for symbols

Insert a new column next to your checkboxes to act as the placeholder for the visual symbols. Hide the original checkboxes or the True/False linked cells if necessary.

Write the VBA evaluation script

Open the VBA Editor (Alt + F11) and write a loop or specific statements to check the value of each control. For example: If CheckBox1.Value = True Then.

Insert Unicode characters into cells

Within your VBA IF statement, assign the checked symbol using ChrW(&H2611) for True, and the empty box symbol using ChrW(&H2610) for False to your target cells.

Email the updated range

Trigger your existing email macro to send the cell range. The email client will natively read and display the text-based Unicode boxes.

Replace Checkbox States with Unicode Symbols via VBA

Compatibility: Text-based Unicode symbols are universally supported across all major email clients, ensuring your form looks correct on both desktop and mobile devices.

Solution 2

Copy and Email the Excel Form as an Image

If preserving the exact graphical layout of the ActiveX controls is crucial, use VBA to copy the selected range as a picture before attaching it to the email body.

Create and Share Forms Easily with WPS Office

Struggling with missing checkboxes and complex VBA workarounds? WPS Spreadsheet offers full compatibility with Excel macros (.xlsm) and features a seamless built-in PDF exporter to guarantee your forms look exactly the way you designed them when shared.

1. Open your form in WPS Spreadsheet: Launch WPS Office and open your existing Excel workbook containing the form and VBA macros.
2. Export the form to PDF: Instead of relying on HTML email scripts, click on 'Menu' and select 'Export to PDF'. This locks in the visual state of all checkboxes flawlessly.
3. Share the document: Use the built-in 'Email' function in WPS Office to instantly attach the perfectly formatted PDF to your outgoing message.

Excellent compatibility with Microsoft Excel VBA and .xlsm formatsBuilt-in Export to PDF feature to preserve visual checkboxes instantlyFree, lightweight, and fast office suiteFamiliar tabbed user interface for easy navigation

Frequently Asked Questions

Why do ActiveX checkboxes show as True/False in emails?

When an Excel range is emailed, the selection is converted into a basic HTML table. Standard HTML email bodies do not support rendering Excel's interactive ActiveX controls, so the email client only pulls the underlying data (True or False) from the cells linked to those boxes.

Can I use standard Form Controls instead of ActiveX controls to fix this?

No, standard Form Controls suffer from the same limitation when sending a raw cell range via email. The HTML conversion process strips out both Form Controls and ActiveX objects. You must use text symbols, images, or PDF attachments to preserve their appearance.

Is it possible to attach the Excel file instead of putting the form in the email body?

Yes, attaching the actual .xlsx or .xlsm file is the most reliable way to preserve full interactivity and visual fidelity. You can modify your VBA code to use the '.Attachments.Add' method in Outlook to attach the workbook instead of copying the cell range.

Excel & Data Problems