Combo box of all worksheet names in a workgroup
Posted on 2001-06-16
I want to create a list box or combobox preferrably with the titles of the other worksheets in a workbook. There are many worksheets, and when I create a new one, I ould like the list to update.
Also on mouse click of a particular worksheet name in the list I need the user to be able to go to that worksheet.
I would appreciate some code for this as I have little VB or excel programming skills.