Command button "return" key

[randell.graybill]

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.

[Leith Ross]

Hello randell.graybill,

You need to use the KeyPress event to capture athe "Enter" key

Please Login or Register  to view this content.

[randell.graybill]

Thanks I'll play around with it and see if I can figure out how to use the code you provided.

[royUK]

This works as well

Please Login or Register  to view this content.