Enter key selecting item in list box on a user form

    Hate to ask a probably dumb question but is it possible to use the enter key to run a macro or prevent the enter key from hiding a non modal userform?


    Thanks

    Re: Enter key selecting item in list box on a user form


    Have a look at ONKEY method in VBA Help.


    However, that said, I don't personally think that using the Enter Key for this task is a wise idea given it is set at application level...

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login