Select Worksheet via Box in VBA

[taya]

Hello,

I have an excel macro that opens the file open box. From there I can select whatever file I need and, based on which version of the macro I am using, it will then highlight the needed data. From there the code closes that workbook and paste the data into the initial master document. My question is, is there a way to have a box appear after the file open box that lets the user then select a worksheet inside that new document? I did not think my code was needed for this and I have tried several variations of the simple line-

Please Login or Register  to view this content.

So I am hoping there is a way to open a box that then shows the worksheets in the current workbook for the user to select.

Is this even possible?

Thank you for any help,
Taya

[Domski]

You could maybe use the built in "More Sheets..." dialogue:

Please Login or Register  to view this content.

Hope it helps,

Dom

[Domski]

If you want to use a UserForm which would give you more control of what happens once the user has selected a sheet this might be of use.

Dom

[taya]

Thank you that is very helpful. I am working on integrating that into my code, which im not 100% sure on how to do. But I think I can make some progress.

This is my code before your comment.

[
Thank you and if you have any more thoughts feel free to post them.

Taya

[taya]

I imported the userform and inserted

Please Login or Register  to view this content.

into code. Worked perfectly.

The only other change would be to put a box in for the user to select cells instead of having the static copy paste cells. I understand how to create the userform a bit more now but was not sure if this idea is viable and I should spend time programing it.

Thanks for your help and input.

Taya

[taya]

I solved this issue by insering

Please Login or Register  to view this content.

into my code.

Thanks for the help,

Taya