VBA UDF question (xl2k sr1)

Topic

New Reply

I have a UDF in my personal.xls. I wanted to call it from a module in another workbook, but couldn’t figure out a syntax to make it work. How is this done?

Thanks,
Ken

Reply | Quote

Replies

Could you make it an add-in(XLA)…It would make life simpler

Reply | Quote

Yet another option: let’s say that you have a function MyFunc in a module in Personal.xls that takes one argument. You can call it from a module in another workbook as follows:

Dim a As Single
a = Application.Run(“Personal.xls!MyFunc”, 10)

Note that the first (and in this example only) argument to MyFunc is passed as the second argument of Application.Run. You can *not* use something like Application.Run(“Personal.xls!MyFunc(10)”) – it’ll return an error.

Reply | Quote

Thanks Jezza, Rory, and Hans. Got lots of options now.

Ken

Reply | Quote

You can set a reference to your Personal.xls file in the VBProject for the workbook you wish to use the function in.

Reply | Quote