Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Programming help | Excel Discussion (Misc queries) | |||
Programming | Excel Programming | |||
programming VBA | Excel Programming | |||
Programming to VBE | Excel Programming | |||
Programming lag | Excel Programming |