Userform preparation for sheet selection

[mahaboobk]

Hello,
This is a question - suggest me how to create the userform :
The user gets all the sheets names from workbook to select from the dropdown.
For example, from examplesample.xlsx, selects sheet (one 1) (below user form)
And provide the destination to save (Provide output path - D: /path/One 1) as below screen
userform.JPGI want to run sheet one 1, selected from ‘user form’ and click submit

 

[Fluff]

Duplicate USER FORM

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).