macro to run automatically when a field is updated
in [Word VBA]
|
From: TheRoundPen on 9 Mar 2010 13:58 I have two form fields on an employee appraisal form. One calculates a grand average score from four different scoring areas on the form. The second field evaluates this score (using a macro) to determine the increase percentage based on the grand score. This macro is assigned to the field to run on entry. My problem is that if an evaluator goes back through the form and changes a score, they must click in this percentage field to get it to update to the correct value. My question is: how could I make this field update automatically anytime a change is made anywhere on the form? Thank you for ANY assistance you can give!
From: macropod on 9 Mar 2010 16:13 Hi TheRoundPen, So why not call the macro via to 'on exit' property of the fields concerned? If necessary, you could incorporate a test in the macro to exit without doing anything if some condition (eg some of the scores have not been entered) isn't met. -- Cheers macropod [Microsoft MVP - Word] "TheRoundPen" <TheRoundPen(a)discussions.microsoft.com> wrote in message news:9876C439-9520-475A-AA35-0D24E8F8F967(a)microsoft.com... >I have two form fields on an employee appraisal form. One calculates a grand > average score from four different scoring areas on the form. The second field > evaluates this score (using a macro) to determine the increase percentage > based on the grand score. This macro is assigned to the field to run on > entry. > > My problem is that if an evaluator goes back through the form and changes a > score, they must click in this percentage field to get it to update to the > correct value. > > My question is: how could I make this field update automatically anytime a > change is made anywhere on the form? > > Thank you for ANY assistance you can give!
|
Pages: 1 Prev: Retrieving table style information Next: Preventing users from entering the header |