Consulting

Results 1 to 4 of 4

Thread: Macro to auto update calculation

  1. #1

    Macro to auto update calculation

    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.

  2. #2
    VBAX Contributor
    Joined
    Jul 2020
    Location
    Sun Prairie
    Posts
    123
    Location
    It depends on the field. Is this in a protected form using legacy formfields?

  3. #3
    I dont intend to protect the form. I have been thinking the whole night, can a simple checkbox content control do the job?

  4. #4
    Knowledge Base Approver VBAX Guru macropod's Avatar
    Joined
    Jul 2008
    Posts
    4,435
    Location
    Quote Originally Posted by elaineada75 View Post
    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)
    Cheers
    Paul Edstein
    [Fmr MS MVP - Word]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •