How to Replace Table Text with Wingdings Check Marks Using Word Macro
Question details
The user wants to create a Word macro that automatically finds and replaces specific text (such as TRUE and FALSE) inside table cells with Wingdings check marks and empty cells.

- Product
- Word
- Device & OS
- Mac
- Scenario
- Automating document formatting by converting text-based boolean values within tables into visual Wingdings check mark symbols.
- Observed behavior
- Running a broad or inefficient macro causes Word for Mac to freeze (displaying the spinning beach ball) and may unintentionally modify text outside of the document's tables.
Always create a backup copy of your Word document before running any new macros, as automated find-and-replace operations can sometimes affect unintended content or cause the application to freeze.
Create a Targeted Macro to Replace Text in Table Ranges
Use a VBA macro that loops specifically through document tables to replace text with Wingdings characters while disabling screen updating to prevent application freezes.
By restricting the Find and Replace operation to your table ranges, you prevent the macro from modifying content outside your tables. Disabling screen updating during execution significantly improves performance and prevents Word for Mac from becoming unresponsive.
In Word, press Option + F11 (Mac) or go to the Developer tab and click 'Visual Basic' to open the VBA editor.
Click 'Insert' > 'Module' from the top menu to create a blank script window where you can write your macro.
Enter a VBA script that loops through each Table in ActiveDocument.Tables. Set Application.ScreenUpdating = False at the very beginning of your code.
Within the table loop, target the Table.Range. Set the find text to 'TRUE', the replacement text to 'P', and apply the Wingdings 2 font to the replacement. Add another find/replace command to replace 'FALSE' with nothing.
Save your code, close the Visual Basic editor, and run the macro from the Developer tab to instantly update your tables.

Automate Text Replacements Efficiently with WPS Writer
WPS Office provides robust document editing capabilities, including support for VBA macros in specific versions. You can easily automate table formatting and targeted text replacements without experiencing heavy performance lags.
- 1. Open Document in WPS Writer: Launch WPS Office and open your .docx document containing the tables you want to format.
- 2. Access the Developer Tools: Go to the Developer tab on the top ribbon and click on 'Macros' or 'Visual Basic Editor' (ensure your WPS version includes the VBA module).
- 3. Add and Run Your Macro: Paste your table-looping VBA code to replace 'TRUE' with the Wingdings 'P' character and execute it safely within WPS Writer.

Frequently Asked Questions
Why does my macro cause Word for Mac to freeze with a spinning beach ball?
This typically happens when a macro updates the screen for every single replacement or searches the entire document inefficiently. Adding 'Application.ScreenUpdating = False' at the start of your macro and restricting the search range specifically to tables will resolve the freezing issue.
How do I manually type a Wingdings check mark in Word?
You can manually insert a check mark by selecting the text, changing the font to 'Wingdings 2', and typing a capital 'P'. Alternatively, go to the Insert tab, click Symbol, select the Wingdings font, and insert the check mark manually.
Will replacing text in tables affect other parts of my Word document?
No, as long as your macro is written to specifically loop through 'ActiveDocument.Tables' and applies the Find/Replace method only to 'Table.Range'. Any text outside of the document's tables will remain completely unaffected.




