xla programming
 

I'm managing/developing an addin, OurFuncs.xla, for our company. This xla
contains lots of UDFs used by many users. To provide a simple helpfunction
for the users I hav done this:

In Sheet1 in the xla I have the UDFs name in A1:A20 and the descriptions of
the UDFs in B1:B20. I have made an userform, Userform1, and placed a
combobox, Combobox1, in this userform. My problem is that I'm having trouble
setting the rowsource for the combobox. Among others I have tried this:
Workbooks("OurFuncs.xla").Worksheets("Sheet1").Ran ge("A1:B20") as the
rowsource, but whatever I try it bombs out with: "Invalid ...... etc". Does
anybody have a solution to this, or has anybody another clever and simple(!)
idea for making such a helpfunction in an xla.

knut

xla programming
 

combobox1.RowSource = _
Workbooks("OurFuncs.xla").Worksheets("Sheet1").Ran ge("A1:B20").Address(Exter
nal:=True)


or
combobox1.RowSource = "[OurFuncs.xls]Sheet1!A1:B20"

--
Regards,
Tom Ogilvy

"DS NTE" wrote in message
...
I'm managing/developing an addin, OurFuncs.xla, for our company. This xla
contains lots of UDFs used by many users. To provide a simple helpfunction
for the users I hav done this:

In Sheet1 in the xla I have the UDFs name in A1:A20 and the descriptions
of
the UDFs in B1:B20. I have made an userform, Userform1, and placed a
combobox, Combobox1, in this userform. My problem is that I'm having
trouble
setting the rowsource for the combobox. Among others I have tried this:
Workbooks("OurFuncs.xla").Worksheets("Sheet1").Ran ge("A1:B20") as the
rowsource, but whatever I try it bombs out with: "Invalid ...... etc".
Does
anybody have a solution to this, or has anybody another clever and
simple(!)
idea for making such a helpfunction in an xla.

knut

xla programming
 

Thanks - will give it a try.

knut
"Tom Ogilvy" skrev i melding
...
combobox1.RowSource = _
Workbooks("OurFuncs.xla").Worksheets("Sheet1").Ran ge("A1:B20").Address(Exter
nal:=True)


or
combobox1.RowSource = "[OurFuncs.xls]Sheet1!A1:B20"

--
Regards,
Tom Ogilvy

"DS NTE" wrote in message
...
I'm managing/developing an addin, OurFuncs.xla, for our company. This xla
contains lots of UDFs used by many users. To provide a simple
helpfunction
for the users I hav done this:

In Sheet1 in the xla I have the UDFs name in A1:A20 and the descriptions
of
the UDFs in B1:B20. I have made an userform, Userform1, and placed a
combobox, Combobox1, in this userform. My problem is that I'm having
trouble
setting the rowsource for the combobox. Among others I have tried this:
Workbooks("OurFuncs.xla").Worksheets("Sheet1").Ran ge("A1:B20") as the
rowsource, but whatever I try it bombs out with: "Invalid ...... etc".
Does
anybody have a solution to this, or has anybody another clever and
simple(!)
idea for making such a helpfunction in an xla.

knut