I have 7 sheets in a workbook and 6 of them have multiple tables on them. I created a userform that has to combo boxes on it. the first allows the user to select a sheet. the second is well..blank.
1. I wish to populate a list of all the tables in my workbook into the combo box.
2. I wish to apply a filter to the combo box that will only show the tables listed on a sheet that was selected in a previous combo box.
help with one or both questions would be greatly appreciated.
chollo
1. I wish to populate a list of all the tables in my workbook into the combo box.
2. I wish to apply a filter to the combo box that will only show the tables listed on a sheet that was selected in a previous combo box.
help with one or both questions would be greatly appreciated.
chollo