Load Listbox into Word form from an Excel workbook

Visor · #5 07-20-2020, 09:58 AM

Greetings, you are very right
I did not try much. The code became confusing to me, and I have already lost several files for misinterpreting the codes. I've been used to seeing and using it like this:

HTML Code:

''ListBox1.RowSource = "'" & GENTEST.Sheets("Hoja5").Name & "'!A1:B" & wbLibroOrigen.Sheets("Hoja5").Range("A" & Rows.Count).End(xlUp).Row

... and, In the provided code I do not distinguish from where to where it loads the listbox..

But I understood I passed the Function to a module and it was not the name of the sheet, but the Listbox .... sorry!
with these fixes ..
It works!!! Great, and the Excel file no longer becomes Read Only ...
I am really very grateful !!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Multiselect listbox - custom outlook form	A_Balt	Outlook	0	07-19-2018 09:36 AM
Add additional column to a listbox in form.	14spar15	Excel Programming	2	06-02-2018 06:01 PM
Macro Personal Workbook does not load in Excel 2016	Intruder	Excel Programming	0	01-21-2017 05:44 AM
Personal Macro Workbook Does Not Load	WRowan	Excel	1	06-23-2016 08:26 AM
Data from Excel to Listbox multiselect to Word	marksm33	Word VBA	2	02-18-2014 08:30 AM