I am developing a complex workbook with approx. 160 worksheets. I want to set up the first page with some combo boxes that will give the users a choice of most appropriate worksheets to select and go to.
I have set up a list called sheetlist which names the worksheets I want the first combo box to be able to navigate to.
I can I put the list in sheetlist into a combo box and then allow users to select the name from the combo box to navigate to the sheet chosen.
I'm not sure whether I should use form control or active x control combo box.
Any help would be appreciated.