Pressing Enter in a User Form

[Cissy]

Hi,

Is there a way to allow the use of the Enter key to move forward through the
fields of a user form instead of the tab key? Thanks

 

[Jay Freedman]

Hi,

Is there a way to allow the use of the Enter key to move forward
through the fields of a user form instead of the tab key? Thanks

Yes, see http://support.microsoft.com/?kbid=187985.

 

[Erica Lais]

Hi,

I have read this article in order to "code the Enter Key to move to next
field in protected form" . There are 4 macros...I have implemented the first
3 Macros, but it does not work...in my form fields I set "run Macro" and I
calculate on entry the first macro (EnterKey). What do I need to do ? Do i
need to calculate the second macro as exit ??

Thank you!

 

[Tony Jollans]

If the code is in either your document containing the form or the template
on which it is based then you should not need to do anything else (except
that after adding the code it won't have any effect until you create or open
a document). You do not need to set any Entry or Exit macros for any fields.

Having just answered another question on this somewhere, I would suggest
that you do not use this code either in normal.dot or in any document based
on normal.dot.

 

[Joann K.]

Thanks for this - I added the macros and they perform as promised but have a
major problem... when using the TAB key, the field is updated with its
relevant stuff (date formatting, calculations, etc) but this does not happen
when I press Enter. Is there something that can be added to the macros to
update the fields once ENTER is pressed?