ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Using the ENTER key to move between form fields? (https://www.excelbanter.com/excel-programming/333438-using-enter-key-move-between-form-fields.html)

drvmac

Using the ENTER key to move between form fields?
 
I have a VBA program that calls a user form and when I press enter it
executes the "OK" button logic. However, when this form calls an optional
second user form which is overlayed over the first, the enter key tabs
between form fields. The form properties as best I can determine are
identical.

Chip Pearson

Using the ENTER key to move between form fields?
 
Are you sure that the Default property of the OK button is set to
True on the second form?


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"drvmac" wrote in message
...
I have a VBA program that calls a user form and when I press
enter it
executes the "OK" button logic. However, when this form calls
an optional
second user form which is overlayed over the first, the enter
key tabs
between form fields. The form properties as best I can
determine are
identical.





All times are GMT +1. The time now is 05:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com