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 |
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 |