How to bind CTRL-ENTER to my UserForm's submit button?

[thornomad]

I have a UserForm and on it is a "submit" button. I would like to bind CTRL-ENTER to the submit button (so a user can submit the form without having to tab all the way to the "submit" button each time).

How would I do that?

Thanks!
Damon

[davesexcel]

Are you making a selection before you show the userform example:

    Selection = "=6*8+RC[1]"

[romperstomper]

If you set the button's Default property to True, then you can just press Enter to fire it.

[thornomad]

If you set the button's Default property to True, then you can just press Enter to fire it.

Oh - perfect, that was just what I was looking for. Works like a charm.

Are you making a selection before you show the userform example:

No - I wasn't. But, the second suggestion works! Thanks.