External Excel files open and edit with multi column databases from one mask Excel VBA

https://excel.hpage.com/external-excel-files-open-and-edit-with-multi-column-databases-from-one-mask-excel-vba.html Open and edit external Excel files with multi-column databases from a single form. Excel VBA. This program creates and manages multi-column databases in external Excel files. Everything works simply: an Excel file is opened from the form, and you can enter data into each worksheet of the opened Excel file in 10,001 rows and 121 columns. Headings are entered in row 1. In column 1, the program creates the identification numbers, each number for a single row and each number that appears only once on the sheet. The remaining 120 columns are divided into 10 groups. Each group can be given a label, and each column with a heading is assigned a data type: text, number, date, or time. All this is done in the "Database Constructor" mode. This mode also determines whether files are entered from a text field or a combo box. In "Enter" mode, data is entered into the database, adhering to the data type assignment. No editing controls are displayed for columns without headings. An image can be added to each ID number. For more information, please see the page; the link to this page is in the description of this video.