Can a Combobox in a Userform access multiple dynamic tables
 

Hi all.

I would like to be able to update numerous tables with the one UserForm. The particular Table would be selected from the UserForm via a ComboBox. All Tables are dynamic and on the same sheet.

I have 2 command buttons, each opening a UserForm; One UserForm to enter new data into the selected Table, the other to amend and, or delete existing data in the selected Table.

In the first UserForm, there is a dropdown menu (ComboBox) to select the Table in which the information is to go, and 2 text boxes for the information that is to be entered. (The tables have 2 columns)
The second UserForm is a little more complicated. There are 2 dropdown menus (ComboBoxes). The first is to select the Table in which to edit and the second to select the row that needs editing or deleting. Like the first Userform, this one also has 2 text boxes for the information that is to be entered or in this case altered.

If possible, the code should include sorting the table after the information has been entered. If this is not possible, then a separate ‘Sort’ button in the userform is required.

I have a sample workbook that I can show, if needed.

Any and all help would be greatly appreciated.