Jumping/Skipping Form...

[TomorrowsMan]

Howdy again,

I have a locked Word document with several form fields that have macros
that calculate on Exit. The macros are fine (thanks to help from many
of you!); however, each time I tab out of a field to go to the next
field, the entire screen 'jumps' first (obviously as the macro
calculates); then, although the next subsequent field to be filled is
selected, it is all the way down at the bottom of the document.

1. Is there a way for me to prevent this skipping/jumping when my
macros run on exit?

And,

2. Is there a way to have the next form field be centered on the
screen, i.e., the document scrolls up instead of showing just enough of
the page to display the form field?

Cheers!

Chris

 

[Jezebel]

1. Your macros can switch off screenupdating while they run. (If that is
what's causing it. Macros don't, in themselves, update the display unless
you're doing things with the Selection object or changing graphic features.)

2. You can use the Information() function to work out what's displayed and
use the Scroll methods to adjust. But before you get carried away, check
that it does make life easier for the user -- scrolling is usually a user
function, so it might be more disconcerting than helpful.

 

[TomorrowsMan]

Actually, it isn't the scrolling that's the issue; each time the user
tabs out of a field that has an OnExit macro calculation, the page that
the field is on moves, as if the macro is moving through the fields it
is calculating, one of which is on a previous page. I'm unsure what is
causing it, or how to fix it; I read somewhere else that it could have
to do with how I have the Selection object being accessed, and I should
possibly be using an array......? That's beyond me, to be honest.

The macro is simple enough; the user selects a value from a dropdown
box on page 3, which gets multiplied by a percentage that was entered
earlier, on page 2. I think for each of the five dropdown boxes, the
macro is jumping the view to the previous page to grab the percentage
field, then jumping back.

Hope this clarifies it a bit better....sorry for the confusion!

Chris

 

[Jean-Guy Marcil]

TomorrowsMan was telling us:
TomorrowsMan nous racontait que :

Actually, it isn't the scrolling that's the issue; each time the user
tabs out of a field that has an OnExit macro calculation, the page
that the field is on moves, as if the macro is moving through the
fields it is calculating, one of which is on a previous page. I'm
unsure what is causing it, or how to fix it; I read somewhere else
that it could have to do with how I have the Selection object being
accessed, and I should possibly be using an array......? That's
beyond me, to be honest.

The macro is simple enough; the user selects a value from a dropdown
box on page 3, which gets multiplied by a percentage that was entered
earlier, on page 2. I think for each of the five dropdown boxes, the
macro is jumping the view to the previous page to grab the percentage
field, then jumping back.

Show us your code.

--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
(e-mail address removed)
Word MVP site: http://www.word.mvps.org

 

[Jezebel]

Macros don't jump. Are you selecting the field in order to retrieve the
value? -- IN which case, change the code so the word "Select" doesn't appear
in it anywhere. Work entirely with Range objects.