| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| personal.xlsb | Excel Discussion (Misc queries) | |||
| PERSONAL.XLSB | Excel Programming | |||
| personal.xlsb file | Excel Discussion (Misc queries) | |||
Linear Mode
