How create my own Funtion

[Alejandro Garcia]

I need create a funtcion and use it in all book, in all sheet. I have
the function but I don't know how use it like, =MyFunction() in
something books.

Thanks.

Sorry, my English isn't good.

 

[Bernard Liengme]

You need to add the function to the PERSONAL.XLS file to be able to use it
in all files.
Learn something about VBA from David McRitchie's site on "getting started"
with VBA

http://www.mvps.org/dmcritchie/excel/getstarted.htm
best wishes

 

[Don Guillett]

simplest explanation
=myfunction(x)

function myfunction
myfunction=x*3
end sub

 

[Guest]

Try the instructions here, Alejandro:
http://www.vertex42.com/ExcelArticles/user-defined-functions.html

 

[Alejandro Garcia]

All you say me, I know, but if I try this, I don't use my function with
all books, if I close the Personal.xls and I open other book, don't do
it anything.

But, I try and later I say you.

Thanks.

 

[Bernard Liengme]

Personal.xls should always be open. Generally it is hidden

 

[Guest]

personal.xls is not designed to be closed, but left open (though hidden).
Perhaps the problem isn't your function but your understanding of
personal.xls. It must be stored in your XLStart folder. Save personal.xls.
Hide it. Close it (hit save to keep it hidden). Close Excel. When you restart
Excel, you should see a blank workbook, but you should also be able to go to
Window-->Unhide and see personal.xls...

 

[Alejandro Garcia]

Gentlemen, thank you for your answers, I place my Personal.xls in the
corresponding folder. The problem is that I have a program in Vfp that
exports a list to Excel opening it immediately, this list is the fact
that I need to apply my function to it, but when I want to make it, it
me does not appear when I press Atl+F8, that I must do?.

Thanks.