Easily Tab/Enter Through Input Forms in Excel - Faster/Better Forms in Excel

How to make forms in Excel that are very easy to input data into because you can hit Tab or Enter in the form and it will take you to the next input field. This tutorial also shows you how to make and use the macro that saves data onto a separate worksheet.

The premise of this tutorial is to make an input form in Excel that is very easy to use and very hard to mess-up. Such a form will improve your efficiency and make it much easier to quickly input data into Excel.

This Excel tutorial combines a few different features to create a usable input form:
- cell locking/unlocking
- protecting worksheets
- simple but effective formatting
- vba/macro that is simple, easy to customize, and explained

I hope you enjoy this tutorial and can make a great input form with it!

#excel #tutorial #howto

[IvanCortinas_ES]

Great tutorial!
Very useful for less advanced users who have to enter data in a form. Thank you!!!

[dannyyeoh]

Wow, I have been looking for the cell tabbing method for a long time. You make it so simple with no coding.. Thanks a lot for sharing this knowledge

[mariarib]

This was great. I have strong Excel skill but done some of this stuff I have rarely used in a couple decades and I was able to click around and fill in the things lost!

[muhammadaldy]

Thanks bro, for more than 3 hours to find a way on youtube how to like your video, once again thankyu...

[angelar]

Thank you very much for the tutorial, your explanation through a small example does help for VBA beginner like me!

[Angel_Alvarez_Concepcion]

Excelente trabajo ingeniero gracias por la información y abrazos desde Puerto Rico 🇵🇷

[wayneedmondson]

Thanks. Nice example. One small trick I use.. for the input cells, if you add an upper and left cell border that is say 2 grades darker than your grey background and use a line style of the thickest or next to thickest option possible, then your fields will have that "sunken" look of a data entry field vs. just the flat look of a cell. It makes users comfortable and familiar with the input area, as it matches that of a dialog box or typical sunken input fields that they encounter in other software. Hope someone finds this useful. Thanks for the videos, tips, techniques and code examples. Thumbs up!! PS - You can use the same technique to the right and bottom of the entire greyed out range to make it look raised up which some find appealing :))

[lisacapamagian]

Some great tips and a nice form structure

[arduinoguru]

Very excellent job man, this is what I was looking for.

[darrylmorgan]

Nice Concept Of Building Forms, Really Neat Bit Of VBA Simple But Powerful...Thank You Sir :)

[navkarenterprises]

Very Helpful and Informative.
Helped me solve my problem.

[yamax]

I see magic -) Exactly what I was looking for. Great Thanks

[tonyhac]

All are very good..but after entering the information, pressing the enter button on the keyboard and running the macro yourself would be better.

[tUtU_]

Lot of missing information such as how do we link two sheets

It did not work for me

[jamescherehani]

This is excellent. I need your help. How can I make data Base form that can allow me to enter marks of different subjects, and find position average, total, and prepare parents report cards automatic?

[BabyAlexis]

Where do you get the store_data macro?

[dandan]

How can you keep undo button with macro

[sirexilon]

Well it looks nice and simple enough but I can't get the VBA to work it keeps debugging, Maybe MS disabled VBA or something by now.

[ericgutierrez]

Do you have this same example but instead of the inputs going into cells on another sheet, the inputs go into a table. I did this but I can't get the values into a table.

[MrRoris]

Hello, how can I program another button that will delete the last entries?