Thank you for the reply.

I don't think I provided enough detail with what I want to do.

I have a command button that uses the code I posted, and I have a button in the cell below that one, which I want to open to the folder that was selected with the previous command, so that the user will be able to select a file from that folder and it will copy the path of that file to cell "B6." If that makes sense.