Log in

View Full Version : Import Data to Word UserForm from Excel spreadsheet



phiko73
12-29-2018, 12:23 PM
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!

macropod
12-29-2018, 10:05 PM
Cross-posted at: https://www.excelforum.com/excel-programming-vba-macros/1258175-import-data-to-word-userform-from-excel-spreadsheet.html
Please read VBA Express' policy on Cross-Posting in item 3 of the rules: http://www.vbaexpress.com/forum/faq.php?faq=new_faq_item#faq_new_faq_item3