I have one workbook (WB1) with an UserForm1 that contains a listbox. The source for this list is a predetermined range (rngVariableWB2) from a second workbook (WB2). The row count for this range may vary and its first line is not the spreadsheet first line, which means the range will be between two others ranges. I don't know if it helps, but both workbook are stored in the same folder. does anyone how can I populate the listbox in wb1 with the values list from wb2? Thanks.
Hi, just as a start try to read this http://www.exceltip.com/user-forms-i...oft-excel.html
and then try
Please Login or Register to view this content.
Regards, John55
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
...enjoy -funny parrots-
The solution depends on how the "predetermined" range was set. If that other workbook uses a dynamic range, then it is simple. If the range a column data, a row, or columns and rows?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks