I've created a data entry form on a worksheet. To confirm the entered details, and clear the existing data I've added a macro and applied that to a shape, to be used as a button, on the worksheet.
The macro works when I click the shape/button so thats all fine.
I'd like to have it so that the user presses the 'enter' or 'tab' keys to move between fields in the form. Once all fields have been filled, the 'tab' or 'enter' key should move to the shape, and then pressing 'enter' would run the macro to confirm the data and clear it.
Is that possible?
If not, is there anothe way to acheive what I'm looking for without using the excel stock buttons?
Bookmarks