I wish to set up a combo box with a drop down list of group names (eg team 1, team 2 etc) which are referenced and counted on several other tabs on the spreadsheet. The tabs which reference these names are called teamnames1, teamnames2 etc
What is the VB code to dynamically update my page with a count of the names on each of the other 'teamnames' tabs.
Also, how do I input this code into the combo box?
What is the VB code to dynamically update my page with a count of the names on each of the other 'teamnames' tabs.
Also, how do I input this code into the combo box?
