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 row that correlates to their requirements 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!

Cross-posted at: https://www.excelforum.com/excel-pro...readsheet.html
Please read VBA Express' policy on Cross-Posting in item 3 of the rules: http://www.vbaexpress.com/forum/faq...._new_faq_item3