List of tab names so you can either click or arrow down to make a selection). Here is it, presented as I originally posted it (basically, it shows a ListBox of all sheets which you can click directly in (and get taken to the clicked on tab name) or start to type the beginning text of a tab name into a text box which will parse down the UserForm solution I posted several years ago to an old newsgroup might work out nicely for you. I think I have a workable solution for you that does a little more than you have asked for.
You cannot put hyperlinks in a ComboBox I would note, though, that a ComboBox would not be the best way to display 50 items for the purpost you want. Any furthermore you can place all in your PERSONAL.XLSB and have this feature in all of your files, because the userform determines the active workbook. The next step is to create a simple macro that starts this form, like this:Īnd assign this macro to a key. you can close it by double click an item or press ESC or ENTER. Private Sub ListBox1_DblClick(ByVal Cancel As MSForms.ReturnBoolean)Īs you see the userform determines all names of all sheets be itself an let you easely choose and switch to any sheet.
Please create such a userform and add this code in the code module of that form: A listbox is better for this.īut a listbox at every sheet is superfluous, an easy universal way is a userform with one listbox and one commandbutton on it. If you want to go to the hyperlink, you must do it by yourself in the click event of the combobox.īut a combobox is IMHO not the best choise, because if you enter a name it might be wrong and did not match with an existing sheet.
But the hyperlinks seem to get switched to regular text when filling the combo box they don't work as hyperlinks.