Excel VBA functions

  • Thread starter Thread starter Mokey
  • Start date Start date
M

Mokey

I have learned how to make my own Yield function by
writing the code in the VBE window. However, it is saved
in my personal macro workbook and everytime I want to use
it, I have to type out PERSONAL.MYield.MYield
([arguments]). Is there a way to make it so that I can
just type MYield([arguments])?

Bonus - Is there another, more user friendly way to make
your own functions in Excel?
 
Hi Mokey

Check your personal.xls in the VBA editor
Tools>References
You don't have to type the filename then
 
Is that in a form code module or a general module?
Make the function public in a general module.

Public Function MyYeild()

Not

Private Function MyYeild()...

--
John
johnf 202 at hotmail dot com


| I have learned how to make my own Yield function by
| writing the code in the VBE window. However, it is saved
| in my personal macro workbook and everytime I want to use
| it, I have to type out PERSONAL.MYield.MYield
| ([arguments]). Is there a way to make it so that I can
| just type MYield([arguments])?
|
| Bonus - Is there another, more user friendly way to make
| your own functions in Excel?
 
Back
Top