Database constructor in Excel VBA with filter view in list box

This program creates and manages database, which can have up to 17 columns, up to 10,000 rows.

 

The program works with 4 common data types: Text, Number, Date and Time.

 

User can give any column any title and assign data type.

 

Only columns with headings are visible in the input mask, columns without headings are hidden.

 

All input fields in the mask can be seen as a text box or as a combo box. If the constructor has data for combo box in the selected field, the field will be seen as a combo box in the input mask, without the combo box data, the input field will be seen as a TextBox in the input mask. Each combo box can have up to 32 lines.

 

Excel file consists of 3 spreadsheets: Mask, Database and Copy.

Table database is hidden. The current copy of the database is created with the "New copy" button in the "Copy" worksheet.

 

If a filter is applied in the "Copy" spreadsheet, the input mask is exited first. Click on cell A1 in the "Copy" spreadsheet, select "Home", "Sort and Filter", "Filter" in the menu bar.

After that, only filtered values will appear in the list box and only filtered ID numbers. you can see.

 

The width of all columns in the list box is automatically adjusted to the length of the entered data.

 

With a double click of the left mouse button you can select each line in the list field and display it in the input fields.

 

Each entry can be deleted individually. Contents of the whole database can also be deleted, password for deletion is number 3.