How to Use Word Combo Box Values in Formulas and Calculations
Question details
The user needs to multiply values selected from Word combo boxes (such as hourly rates, minutes, and lesson quantities) and automatically calculate the total result in a table cell or an exported PDF.

- Product
- Microsoft Word
- Device & OS
- Mac and Windows
- Scenario
- Creating a dynamic invoice template designed for A4 PDF export, where the user can select numeric values from drop-down menus and have the document automatically compute the final invoice totals.
- Observed behavior
- Standard Word formula fields cannot directly reference content control combo box titles or tags. This prevents automatic calculations from executing when new drop-down values are selected, and the functionality varies significantly between Windows, Mac, and Web versions of Office.
Ensure that the Developer tab is enabled in your Word ribbon, as you will need access to Legacy Forms or VBA macros to configure combo boxes for mathematical calculations.
Use Legacy Drop-Down Form Fields and Table Formulas
Legacy form fields can trigger a calculation on exit and can be easily referenced by bookmarks or table cell addresses, unlike modern content controls.
Modern Content Controls do not natively support direct formula referencing. By using Legacy Form Fields inside a Word table, you can assign them bookmark names or rely on table cell coordinates (e.g., A1, B1) to perform multiplication.
Navigate to the Developer tab, click the 'Legacy Tools' icon (a briefcase folder), and select 'Drop-Down Form Field' to insert it into your desired table cell.
Double-click the inserted form field to open the Drop-Down Form Field Options dialog. Add your numeric options (like hourly rates or quantities) using the 'Add' button.
In the same dialog box, check the 'Calculate on exit' option. Assign a memorable name in the 'Bookmark' field (e.g., 'Rate' or 'Quantity'), then click OK.
Click inside the table cell where you want the total to appear. Press Ctrl+F9 to insert a blank field bracket {}, type your formula (e.g., =Rate*Quantity), and press F9 to update the calculation.

Use VBA Macros to Read Content Control Values
If you are required to use modern content control combo boxes, a VBA macro can be utilized to read their string values, convert them to numbers, and perform the calculation.
Create Dynamic Invoices and Export to PDF with WPS Office
Avoid the complex limitations of Word's content controls and macro compatibility issues across different operating systems. WPS Office offers a highly compatible, free, and lightweight suite where you can easily design professional invoice templates, perform reliable spreadsheet-style calculations natively, and export perfectly to A4 PDF formats without user resistance.
- 1. Download and Install WPS Office: Visit the official WPS website to download the free, lightweight installer for your Windows or Mac device.
- 2. Open Your Invoice Template: Launch WPS Writer and open your existing .docx invoice template. The formatting and table structures will carry over seamlessly.
- 3. Export to A4 PDF: Once your invoice is complete, go to the Menu, select 'Export to PDF', and verify the page layout is set to A4 for perfect print formatting.

Frequently Asked Questions
Why aren't my Word formula fields updating automatically when I change a drop-down value?
Word formula fields do not update automatically in real-time as you type or select new options. You must manually select the formula field (or the entire document using Ctrl+A) and press the F9 key to refresh the calculations, unless you use Legacy Form Fields with the 'Calculate on exit' option enabled.
Can I use content control combo box macros in Word for Mac or the Web?
Word for the Web does not support VBA macros at all. Word for Mac supports VBA, but the functionality and available object model are more restricted compared to the Windows desktop version, which can prevent automated calculation scripts from working properly across all devices.
How do I reference a specific table cell in a Word document formula?
Word tables function similarly to Excel spreadsheets. Columns are represented by letters (A, B, C) and rows are represented by numbers (1, 2, 3). For example, the top-left cell is A1. You can reference it in a formula field by pressing Ctrl+F9 and typing =A1.
How can I ensure my invoice exports to a strict A4 PDF size?
Before exporting, go to the Page Layout tab, click on 'Size', and ensure 'A4' is selected. When your design is complete, use the 'Save As' or 'Export' feature and choose PDF. This preserves the exact A4 layout and dimensions regardless of the device opening the file.




