View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jason Paris[_2_] Jason Paris[_2_] is offline
external usenet poster
 
Posts: 8
Default Linking the ENTER key to a Button on a Form?

Hi folks,

I'm creating a User Form in Excel. It includes a Text Box and a
number of buttons.

When the user types into the Text Box and (instinctively) presses
ENTER, is there a way to simulate the clicking of a button? In other
words, can ENTER - when pressed from the Text Box - be used to trigger
the code behind a button?

Many thanks,

Jason Paris