Data Entry Forms

Occasional Contributor

I am trying to create a form in Excel for data entry.  How do I do this?

 

7 Replies

@Klhoyt149 

Excel has a built-in Data Form. See Quick Access Toolbar 101 | Commands Not in the Ribbon how to add the Form button to the Quick Access Toolbar.

@Hans Vogelaar  I have no form command on my program. I have looked repeatedly. 

@Klhoyt149 

The data form is available in Excel for Windows, but sadly not in Excel for Mac. Are you on Mac?

Yes I am. Are there any other options?

@Klhoyt149 

You'd have to roll your own, but that's a lot of work.

Thank you. I will get it done. I was just hoping for some guidelines.

Data entry form
If you are comfortable with VBA, then you can use below alternative.
https://www.contextures.com/xlForm02.html

Another approach to making a data entry form in Excel is to use the web
https://youtu.be/7UEdYkExwTo