B
borg
Hi,
I would like a rowsource of a textbox in a userform to be reference to an
open but hidden workbook.
I've tried this but it doesn't work:
sub test
with userform1
.listbox1.rowsource=workbooks("book2.xls").worksheets(1).range("A1:A100")
.show
end with
end sub
Thanks a lot!
I would like a rowsource of a textbox in a userform to be reference to an
open but hidden workbook.
I've tried this but it doesn't work:
sub test
with userform1
.listbox1.rowsource=workbooks("book2.xls").worksheets(1).range("A1:A100")
.show
end with
end sub
Thanks a lot!