Assigning controls
We're finally ready to make a form do something. Adding controls to a form is only the first step in creating a working dialog box, or a UserForm. Adding data to a form where controls have not been assigned to certain actions and addresses in the spreadsheet will have no effect at all.
In this recipe, we will be assigning controls to specific fields and objects.
Getting ready
Make a copy of the file we used in Chapter 14, Creating UserForms, and save it as Controls.xlsm. Activate the VBA Editor. New Record Entry Form should be visible, and both the Project window and the Properties window should be visible on the left of the VBA Editor.
How to do it…
We will start with the Save this Entry button. Let's see how it's done:
- On the New Record Entry Form, right-click the Save this Entry button and then choose View Code from the pop-up menu. Alternatively, double-click the button. The code window for the form itself will appear...