© Roy Cox (2005 - 2020)

Page Title

Making Excel work for you.
.

Excel DataBase UserForm

Contrary to what some web sites say, you can actually use Excel quite successfully as a database. Excel has many features that make this possible including Tables, PivotTables and many Data Functions available in Excel’s formulas. Data can be imported from various sources but when it is iinputted by the user manually a UserForm helps ensure that the data is entered in the correct format and place.The example available on this page demonstrates how to use five useful Controls available in the UserForm ToolBox. 1 . TextBoxes: used for data entry and also displaying existing entries for amending those entries. 2 . ScrollBar: this is used to allow the user to scroll the display in the TextBoxes. 3 . Option Buttons: used to allow the user to choose from a preset response, e.g Yes or No. The code also shows how to set the OptionButton from data previously entered to the database. 4 . CommandButtons: used to for various tasks such as adding new entries, deleting or amending. 5 . ListBox: shows data in a Table format on the UserForm. This ListBox becomes available if multipe results are found using the search button. The download comes in a zipped file which also contains a more advanced example of a database userform which can be used as a contacts manager. Although the project is locked you can use this form to keep your own contacts in by replacing the data in the Data sheet with your own work or personal contacts. The Database can display up to ten columns of data and you can change the Column Headings to suit your database needs. Read more and find out how to get the unlocked version here: Contacts Manager Database
If you find this Form useful You can help maintain my site by donating. Simply click the image below
Buy me a coffeeBuy me a coffee

© Ut duis incididunt ex officia

Veniam proident laboris. Deserunt voluptate cillum, laboris culpa nostrud ad, sunt quis. Labore ex minim occaecat ut. Velit in consectetur irure deserunt sit, ea do ut ea in mollit veniam tempor occaecat incididunt, esse id irure.
.

Excel DataBase UserForm

Contrary to what some web sites say, you can actually use Excel quite successfully as a database. Excel has many features that make this possible including Tables, PivotTables and many Data Functions available in Excel’s formulas. Data can be imported from various sources but when it is iinputted by the user manually a UserForm helps ensure that the data is entered in the correct format and place.The example available on this page demonstrates how to use five useful Controls available in the UserForm ToolBox. 1 . TextBoxes: used for data entry and also displaying existing entries for amending those entries. 2 . ScrollBar: this is used to allow the user to scroll the display in the TextBoxes. 3 . Option Buttons: used to allow the user to choose from a preset response, e.g Yes or No. The code also shows how to set the OptionButton from data previously entered to the database. 4 . CommandButtons: used to for various tasks such as adding new entries, deleting or amending. 5 . ListBox: shows data in a Table format on the UserForm. This ListBox becomes available if multipe results are found using the search button. The download comes in a zipped file which also contains a more advanced example of a database userform which can be used as a contacts manager. Although the project is locked you can use this form to keep your own contacts in by replacing the data in the Data sheet with your own work or personal contacts. The Database can display up to ten columns of data and you can change the Column Headings to suit your database needs. Read more and find out how to get the unlocked version here: Contacts Manager Database
Working with data in Excel correctly

Page Title

Logotype