![how to make a data entry form in excel 2013 for mac how to make a data entry form in excel 2013 for mac](https://spreadsheetpage.com/images/Excel-Data-Entry-Form-Dialog-Box-680x261.jpg)
Click in the Default Property box and select True.Ģ6. Change the Caption property of the Command button to OK.Ģ4. Click the Command Button control in the Control toolbox, drag it to the form, and locate it next to the TextName control.Ģ3. Click and drag the right border of the form to increase the form’s size.Ģ2.
![how to make a data entry form in excel 2013 for mac how to make a data entry form in excel 2013 for mac](https://i.pinimg.com/originals/31/68/ac/3168ac491232fac7ea81fa67c8803c9a.png)
Change the Caption property to Graduate School.Ģ1. Change the Check box Name property to OptionGrad.Ģ0. Click and drag the Check box control from the Control toolbox to the form and locate it below the second check box.ġ9. Change the Caption property of the Check box control to College.ġ8. Change the Check box Name property to OptionCollege.ġ7. Click and drag the Check box control to the form and position it below the first check box.ġ6. Change the Caption property of the Check box control to High School.ġ5. Change the Check box Name property to OptionHS.ġ4. Click and drag the Check box control from the Control toolbox to the form and locate it within the frame.ġ3. Click in the Caption property of the Frame control and type Education Level.ġ2. Click and drag the Frame control from the Control toolbox to the form and locate it below the text box.ġ1. Click in the Name property of the Text Box control and type TextName.ġ0. Locate it to the right of the Label control.ĩ. Click the Text Box control in the Control toolbox and drag it to the form. Click in the Label’s Caption property box and type Name.Ĩ. Click the Label control and drag it to the form.ħ. Click in the Caption property box and change the name to Get Name and Education.Ħ. If necessary, press to display Userform1 properties.ĥ. Open a blank worksheet of your workbook.Ĥ. Rather than typing high school, college, or graduate school, you can create a form that allows you simply to check a box to indicate the education level. The form only only contains text box controls, which can be cumbersome when entering certain types of data.įor example, you want to create a table that lists the educational level of your latest batch of job applicants.
How to make a data entry form in excel 2013 for mac how to#
Here's how to set up check boxes that you can later translate into a report you want.Įxcel provides a simple data form to enter data into an Excel database. You can keep a lot of information on an Excel data entry form, but you can make it easier for your users - and yourself - to create tables by adding check boxes. Create an Excel data entry form that includes check boxes