Forms / Command Button Help

  • Thread starter Thread starter Nick
  • Start date Start date
N

Nick

Hi

Does any one know when creating a form which requires you
to click on an accept button to get into the spreadsheet
how you make it so you can press ENTER on the keyborad to
accept rather than having to click on accept with the
mouse?

Thanks
Nick
 
click on the button in your form, hit F4 to see its properties.

Look for Default--set it for true.

Look at VBA's help. And then look at the .cancel property for the "Cancel"
button.

You'll want that, too.
 
Back
Top