'WORD VBA add items to userform listbox from excel file
How can I load items into word userform1 listbox1 from excel file located in desktop file name book1 sheet1 table1 (4 columns A-D)
Solution 1:[1]
MyListBox.List = Application.Workbooks.Open("C:\Users\" & environ("Username") & "\Desktop\Book1.xlsx").Worksheets("Sheet1").ListObjects("Table1").DataBodyRange.Columns(1).Resize(,4).Value
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Toddleson |