| Userforms: Userforms provide a great way to enter data and perform calculations and the data can easily be transferred to the Excel worksheet. The process, however, involves good programming knowledge of Visual Basic for Applications. Once the macro is written the data can be entered in the form. Because most of us are used to entering data in forms, the data entry process is natural and easier if the number of headers crosses a certain limit. You create the same number of text boxes on a form with relevant labels so that data can then be transferred from the userform onto the Excel worksheet. The first step after the creation of the form involves defining a few variables, then finding an empty appropriate row where the data will be filled, copying the data into the Excel cells and finally removing or clearing the data on the form to make way for the next entry. You may also provide for a process or system where the data entry is 'finished' and you can exit the system. We have created such a simple form for making data entries for employees of a company. You might observe some dates as numbers. These can, however, be easily corrected through proper formatting. The training video demonstrates the idea elaborately. | |