Excel VBA Listbox. Filter view in the list box. Automatic column width in the list box

With the program you can manage small database. Everything is done from input mask.

Excel file consists of 3 worksheets: mask, database and copy.

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

List box in the input mask shows the "Database" worksheet and the "Copy" worksheet.

If filters are set in the "Copy" worksheet, only filtered values will appear 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.

With the program you can create 10 000 entries. Each entry can be deleted individually. Content of the entire database can also be deleted, password for deletion is the number 3.