UserForm to choice a worksheet within Workbook

[bod213]

I have a workbook with over a 100 sheets

I want to be able to open the workbook and a Userform appears

Which will then give me the option of a 2 drop list

that I can choose from

that will then open the specific worksheet

[mehmetcik]

Try the attached workbook.

The Userform runs on Auto_Open, also on double click and under macro List_Files.

[bod213]

Thank You

For taking the time to look at my problem

the workbook you sent was maybe a little bit more advance then my knowledge

Pic 4.PNG

and this error message kept popping up

this is what I sort of want to do

Pic 5.PNG

so there would be over a 104 worksheets within the work book

and I would want a quick way to navigate to the right worksheet quickly

[AliGW]

Why don't you just use the built-in right-click option? Hover your cursor over the bottom left of the Excel window (to the left of the arrows < > ) to see the options.

Have a look here: https://www.datanumen.com/blogs/2-me...xcel-workbook/

[bod213]

Thank You

I have a look

[mehmetcik]

That line is trying to set the default folder to your desktop.

Record yourself saving a file to the desktop.

Modify that line to point to your desktop.