I wish to allow a user to navigate to their chosen workbook and then pull
values from specific ranges on a sheet in that workbook, to populate
textboxes in a Userform.

Do I have to open the workbook, please?

Regards.