Consulting

Results 1 to 2 of 2

Thread: Import Data to Word UserForm from Excel spreadsheet

  1. #1
    VBAX Newbie
    Joined
    Dec 2018
    Posts
    1
    Location

    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!

  2. #2
    Knowledge Base Approver VBAX Guru macropod's Avatar
    Joined
    Jul 2008
    Posts
    4,435
    Location
    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

    Cheers
    Paul Edstein
    [Fmr MS MVP - Word]

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •