Home

BriargateExcel has created an enhanced table manager for Excel tables. The enhanced table manager allows the user to maintain an Excel table via a form that's created from the table. The form shows one line of the table at a time and allows the user to navigate through the table, add and delete rows of the table, modify the contents of one row of the table at a time, and verify the modifications against the table's data validation against the form's contents before committing the data in the form to a row of the table.

The user must configure the table by locking/unlocking the columns and setting appropriate data validation for each column of the table.

The user must also make some additions to the file containing the table: add a code module and adjust the file's ability to access the VBA Project.

This Wiki and multiple posts at BriargateExcel.com provide all the instruction needed for the user to take advantage of the capabilities of the BriargateExcel Table Manager.

Here is an example file you can download and try out. You will have to add the xlam file to your add-ins directory to use the example.

Here is an example of what the table manager can do.