joebbshop
New Member
- Joined
- Aug 4, 2009
- Messages
- 26
Hi. I have a complex userform. I've run into a problem where pressing the either of the enter keys (the one on the number pad and/or the one by the letter keys) causes excel to crash & close.
I've tried using an onkey command to disable the enter keys as in this post: http://www.mrexcel.com/forum/excel-questions/77758-disabling-enter-key-while-form-running.html
I've also created a special dummy button which is set as the default button. I've checked the other buttons and they are all set to Default, False. I don't know if other controls (text boxes, labels, listboxes, etc) can be set to default like command buttons can.
It is not a modal userform.
What am I missing? Why is pressing the enter key causing the excel to crash?
I've tried using an onkey command to disable the enter keys as in this post: http://www.mrexcel.com/forum/excel-questions/77758-disabling-enter-key-while-form-running.html
I've also created a special dummy button which is set as the default button. I've checked the other buttons and they are all set to Default, False. I don't know if other controls (text boxes, labels, listboxes, etc) can be set to default like command buttons can.
It is not a modal userform.
What am I missing? Why is pressing the enter key causing the excel to crash?
