View Full Version : [SOLVED:] Macro to auto update calculation
elaineada75
04-21-2022, 06:19 AM
Hi hi
Can a macro be written to auto update calculation instead of manually update the field?
If yes, appreciate if you could share it. Been trying for days still cannot find a way.
Thanks thanks.
Chas Kenyon
04-21-2022, 12:52 PM
It depends on the field. Is this in a protected form using legacy formfields?
elaineada75
04-21-2022, 05:57 PM
I dont intend to protect the form. I have been thinking the whole night, can a simple checkbox content control do the job?
macropod
04-21-2022, 06:16 PM
I have been thinking the whole night, can a simple checkbox content control do the job?
That still wouldn't make the update automatic and would hardly be any more efficient than selecting the field and pressing F9.
Depending on what you're doing, a suitably-coded WindowSelectionChange event-driven macro might do the job. See:
Writing application event procedures (wordmvp.com) (https://wordmvp.com/FAQs/MacrosVBA/AppClassEvents.htm)
Powered by vBulletin® Version 4.2.5 Copyright © 2025 vBulletin Solutions Inc. All rights reserved.