Import Data to Word UserForm from Excel spreadsheet

Hey there. I am still a little new at this and have struggled through a lot of my project already. I have reached a snag.

I currently have a project built in Word that exports UserForm data to a spreadsheet. I want users to be able to retrieve a specific of their choosing from the spreadsheet and import it into the UserForm again. Basically creating a save and open feature within the project.

I have been fidgeting around with using a ListBox to display all candidates in the spreadsheet (limiting the display to just a few specific columns), but so far have had very little success.

If anyone has any advice on something that would work for this, it would be greatly appreciated.

Thanks!

Anyone have any ideas?

I actually removed my code because it wasn't working, so I am starting from scratch. Do you want me to upload the entire project's code?