Forms / Command Button Help

[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

 

[Dave Peterson]

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.