Personal.xls Macro Function for Everyone...

  • Thread starter Thread starter Jairo Marin
  • Start date Start date
J

Jairo Marin

Hey Group!!!


How can I expose a function that I can use after in wherever I want. I tried
the following way, but I couldn't

In Personal.xls in a new Module:

Public Function MyFunction() as string
....Lines
End Function

when I open new.xls
and I write:
CellA1= MyFunction(Some Args)

I am tryieng to use it like Sum(), for example...

It returns to me: N/A

So... it is Impposible????
 
=personal.xls!myfunction(somearguments)

===
If you save the personal file as an Addin, you can refer the functions just like
they're built in.

But you would have to provide some way to get to the macros.
 
Hey THANX!!


Dave Peterson said:
=personal.xls!myfunction(somearguments)

===
If you save the personal file as an Addin, you can refer the functions
just like
they're built in.

But you would have to provide some way to get to the macros.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

user defined functions 3
Call Macro from PERSONAL.XLS 4
VBA Function to evaluate hlookup text string as formula 2
Function parameter description 2
Pass named range to user defined function returns #value! 6
user defined function receiving a range as parameter 7
functions in 'personal.xls' 4
Running a Excel function from access vba 1

Back
Top