Add user defined function in Excel 1

[tmpalaniselvam]

Hi!
I want to add a function into the Excel function List. I have written code for some useful VB functions, but I couldn't know, how to utilize in excel.
Anybody help me...

Thanks,
Palani.

 

[acron]

If you want to have the functions permanently available, you need to store them in a workbook that is stored in your XLStart folder. It is best if the workbook is saved as an AddIn, as that way you do not need to use the workbook name when calling the function. For example if you wanted to use MyFunc(), which is stored in Personal.xls you need to enter it as = Personal.xls!MyFunc(), whereas if it is stored in an AddIn that is loaded you can use =MyFunc().

All userdefined functions that are in any open workbook should be available to the Function Wizard, under the User Defined category. The function name however may be preceded by the workbook name that holds the function.

The best option is to store all your user functions in one workbook, and save it as an AddIn (FileSave As ... and select Microsoft Excel AddIn from th efile type list). If you store it in your XLStart folder it should open each time Excel is opened. Otherwise you need to add it to your AddIns, (Tools, Add-Ins, Browse... and add the file to the list).

Hope you can follow that,

AC

 

[tmpalaniselvam]

Hi!
Thanks a lot,Acron. I follow your way.

Thanks again,
Palani.