How do I code commandbutton1 to be activated when enter is pressed (assuming that a combobox is not currently active.)
This is for a spreadsheet command button.
How do I code commandbutton1 to be activated when enter is pressed (assuming that a combobox is not currently active.)
This is for a spreadsheet command button.
Hello randell.graybill,
You need to use the KeyPress event to capture athe "Enter" key
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Star below the post.3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Thanks I'll play around with it and see if I can figure out how to use the code you provided.
This works as well
Please Login or Register to view this content.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks