Contact E-Mail address:klste@hotmail.de

 

Create multi-column database with search engine and images in Excel VBA yourself

 

Excel VBA. Multi-column database with search engine, images and filters View in the list box

This program is an Excel file programmed in VBA. The program creates and edits Excel database with 140 columns and 5000 rows

The Excel file has 5 worksheets: Mask, Database, Sheet, List and Database2.

In the program everything is done from an input mask. The input mask is activated in the mask sheet with the Mask button.

All data is entered in the database sheet. The database consists of 10 areas, each area has 14 columns.

The names of areas are entered in line 11 and registered names are displayed in the input mask.

Column headings are on line 12. If column has a heading, the column appears in the input mask and can be edited if column does not have a heading, which is not displayed in the input mask.

In mask, right are two buttons "D" and "E".

With the "D" button, a series of 10 yellow buttons (from 1 to 10) is called. Each button is responsible for a database area.

If one of the ten yellow buttons is clicked, it will be red and in mask all registered column headings are from the area for which the button is responsible.

At the bottom of each column heading is a ComboBox, in the combo boxes you can select 4 data types: text, number, date and time. A yellow Fill button maps the selected data types to the selected columns.

The "E" button is used to call up a series of 10 blue buttons (from 1 to 10). Each button is responsible for a database area.

If one of the ten blue buttons is clicked, it will be red and in mask all registered column headings are from the area for which the button is responsible.

At the bottom of each column heading, you can have a white text box or a yellow ComboBox. The Comboboxes are only available if something is entered in the Database tab above the column header in rows 1 through 10. The combo boxes are for recurring terms, such as when column header is "Salutation", in the ComboBox is "Woman" or "Gentleman". The data type assigned to the column is at the bottom of the text box/ComboBox. With blue button "Enter" the contents of the text boxes/combo boxes are stored in the database; Data types that are assigned in format.

At the top right is ComboBox "ID-No.". There are all created ID numbers from the database.

If the ComboBox is empty and record is entered, new ID number is created.

If what is selected in the ComboBox is only entered in the selected ID number.

The “Sheet” button creates a list of all data in the selected ID number in the Sheet view worksheet.

In the Search text box, search is entered and started with the “Find” Button search action. Search is only in the 14 columns in the selected range.

ID number containing the search term are listed in the ComboBox "found in ID no." and in the list sheet. The “List” button displays the list sheet.

The "Database" button creates the current copy of entire database in the "Database2" worksheet. The copy can be evaluated as desired.

If Filter is set in the "Database2" worksheet, only filtered values will be displayed in the list box.

The width of all columns in the list box is automatically adjusted and all values are displayed in full.

By double-clicking the left mouse button, you can select each line in the list box and display it in input fields.

Each ID no. you can add or remove an image with buttons "Remove Image" or remove image, button "remove image" custom password, that is the number 3.

With button "Delete ID No." is selected ID no. deleted, password is the number 3.

The “Delete all“ button clears the contents of the database and the password is 3.

 

 

 

Multi-column database with search engine and images in Excel VBA

This program is an Excel file programmed in VBA. The program creates and edits Excel database with 140 columns and 5000 rows

The Excel file has 5 worksheets: Mask, Database, Sheet, List and Database2.

In the program everything is done from an input mask. The input mask is activated in the mask sheet with the Mask button.

All data is entered in the database sheet. The database consists of 10 areas, each area has 14 columns.

The names of areas are entered in line 11 and registered names are displayed in the input mask.

Column headings are on line 12. If column has a heading, the column appears in the input mask and can be edited if column does not have a heading, which is not displayed in the input mask.

In mask, right are two buttons "D" and "E".

With the "D" button, a series of 10 yellow buttons (from 1 to 10) is called. Each button is responsible for a database area.

If one of the ten yellow buttons is clicked, it will be red and in mask all eigetragene column headings are from the area for which the button is responsible.

At the bottom of each column heading is a ComboBox, in the combo boxes you can select 4 data types: text, number, date and time. A yellow Fill button maps the selected data types to the selected columns.

The "E" button is used to call up a series of 10 blue buttons (from 1 to 10). Each button is responsible for a database area.

If one of the ten blue buttons is clicked, it will be red and in mask all eigetragene column headings are from the area for which the button is responsible.

At the bottom of each column heading, you can have a white text box or a yellow ComboBox. The comboboxes are only available if something is entered in the Database tab above the column header in rows 1 through 10. The combo boxes are for recurring terms, such as when column header is "Salutation", in the ComboBox is "Woman" or "gentleman". The data type assigned to the column is at the bottom of the text box/ComboBox. With blue button "enter" the contents of the text boxes/combo boxes are stored in the database; Data types that are assigned in format.

At the top right is ComboBox "ID-No.". There are all created ID numbers from the database.

If the ComboBox is empty and record is entered, new ID number is created.

If what is selected in the ComboBox is only entered in the selected ID number.

The sheet View button creates a list of all data in the selected ID number in the Sheet view worksheet.

In the Search text box, search is entered and started with the Find Button search action. Search is only in the 14 columns in the selected range.

ID number containing the search term are listed in the ComboBox "found in ID no." and in the list sheet. The list button displays the list sheet.

The delete ID no. button deletes selected ID number, password is the number 3.

Delete All button deletes database contents, password is number 3.

Each ID number can be added to an image, insert image button or remove picture, remove image button.

The database button creates the current copy of the entire database in the Database2 worksheet. The copy can be evaluated in any way.