Drop down box using sheet names

[Mattyads2011]

Hi All.

I need to create a button that displays a drop down box that allows a user to jump to a specific worksheet in an excel document.

The main sticking point is that there may be new sheets added with various names throughout the year that, once created, will need to form part of the drop down menu.

Can this even be done?

 

[Mattyads2011]

Hi Trevor.

Please excuse my late reply, other less interesting projects have come up that have taken prioroty until now.

I still cannot get the drop down box to populate with any thing.

There is no error message and the 'Sheet Names' worksheet is updating with the new tabs added but they still are not appearing in the dropdown box. I am confident I have followed the steps in your previous post.

Any ideas?

Thanks again for your continued support.

 

[Trevor G]

Send me a Private Message and then I will give you an email address then you can send me your workbook to look at.

 

[mrjackg]

Send me a Private Message and then I will give you an email address then you can send me your workbook to look at.

Hi I also am having the same issue, I followed your instructions and have an empty combo box also. Can you please let me know if this was resolved and if so what the issue may have been?

Many thanks