Other Links
This is one of the 33 lessons from the
Tutorial on Excel
Lesson 1-12: Excel Database EntryForm
NOTE: If Excel recognizes your set of data as a database you can sort the data
You don't need to do any VBA programming (macros) to create a form that allows you to enter/delete data in an Excel database.
Once you have created a database in Excel, you can click anywhere in the database and go to the menu bar Data/Form and here comes the form to enter/delete/search/filter data. The fields wont be "Name, "Address" , "City" ...they will be what you have chosen as title in each column of YOUR database.
Instead of using the mouse to move from " Name" to " Address" , to " City" .... use the TAB key.
This is one of the 33 lessons from the
Tutorial on Excel
