UDF in PERSONAL.XLSB
 

Can't a UDF be set in personal.xlsb? I have found only sub-routines to be
working in the same.

--
Best Regards,

Faraz

UDF in PERSONAL.XLSB
 

xlsm right?

If the UDF name is 'GetmyFunction' with an argument; try

=personal.xlsm!GetmyFunction(A1)

If this post helps click Yes
---------------
Jacob Skaria


"Faraz A. Qureshi" wrote:

Can't a UDF be set in personal.xlsb? I have found only sub-routines to be
working in the same.

--
Best Regards,

Faraz

UDF in PERSONAL.XLSB
 

Hi there Jacob!

I am sorry but I don't understand. The personal macro book is PERSONAL.xlsb
isn't it? I have tried to copy some of my UDFs to the same.

--
Best Regards,

Faraz


"Jacob Skaria" wrote:

xlsm right?

If the UDF name is 'GetmyFunction' with an argument; try

=personal.xlsm!GetmyFunction(A1)

If this post helps click Yes
---------------
Jacob Skaria


"Faraz A. Qureshi" wrote:

Can't a UDF be set in personal.xlsb? I have found only sub-routines to be
working in the same.

--
Best Regards,

Faraz

UDF in PERSONAL.XLSB
 

You need to preface the UDF with Personal.xlsb in order to call that UDF from
Personal.xlsb.

=Personal.xlsb!MyUDF(arguments)

If this post helps click Yes
---------------
Jacob Skaria


"Faraz A. Qureshi" wrote:

Hi there Jacob!

I am sorry but I don't understand. The personal macro book is PERSONAL.xlsb
isn't it? I have tried to copy some of my UDFs to the same.

--
Best Regards,

Faraz


"Jacob Skaria" wrote:

xlsm right?

If the UDF name is 'GetmyFunction' with an argument; try

=personal.xlsm!GetmyFunction(A1)

If this post helps click Yes
---------------
Jacob Skaria


"Faraz A. Qureshi" wrote:

Can't a UDF be set in personal.xlsb? I have found only sub-routines to be
working in the same.

--
Best Regards,

Faraz

UDF in PERSONAL.XLSB
 

See also
http://www.rondebruin.nl/personal.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"Jacob Skaria" wrote in message ...
You need to preface the UDF with Personal.xlsb in order to call that UDF from
Personal.xlsb.

=Personal.xlsb!MyUDF(arguments)

If this post helps click Yes
---------------
Jacob Skaria


"Faraz A. Qureshi" wrote:

Hi there Jacob!

I am sorry but I don't understand. The personal macro book is PERSONAL.xlsb
isn't it? I have tried to copy some of my UDFs to the same.

--
Best Regards,

Faraz


"Jacob Skaria" wrote:

xlsm right?

If the UDF name is 'GetmyFunction' with an argument; try

=personal.xlsm!GetmyFunction(A1)

If this post helps click Yes
---------------
Jacob Skaria


"Faraz A. Qureshi" wrote:

Can't a UDF be set in personal.xlsb? I have found only sub-routines to be
working in the same.

--
Best Regards,

Faraz