ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   "Enter"on keyboard problem (https://www.excelbanter.com/excel-programming/286127-enter-keyboard-problem.html)

mike33

"Enter"on keyboard problem
 
Hi,

I'm new to the board as well as programming in VB in general.
Anyways I have a problem on my Form concerning entering data into
text box.

I am able to enter data into a text box. This data goes through
validation check performed on exit.

My problem is, if the data is correct and I press "Enter" on the keypa
instead of "TAB", all other textboxes are skipped and the for
automatically loads.

What I would like to happen is if you press "Enter" on the keypad i
goes to the next textbox.


Thanks in advance for any help!!
Mike

--
Message posted from http://www.ExcelForum.com


mike33[_2_]

"Enter"on keyboard problem
 
Hi everyone,

I just answered my own problem.

FYI:

I did have all the textboxes EnterKeyBehaviour set to "False". So that
was not the problem.

The problem is within the commandbuttons, those are automatically set
to default on a form, so if you press enter, the command button will be
executed.

Make sure on the propery, Default is set to "False".


---
Message posted from http://www.ExcelForum.com/



All times are GMT +1. The time now is 11:27 PM.

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