Calling a function in another module

R

red6000

Hi,

I have a module called myFunctions with many functions in it.

I then have a userform where I then call the functions.

To do this I am using:

myFunctions.nameOfFunction

is there a way I can define myFunctions in the user form to save me having
to keep typing it, ie I want to be able to code with:

f.function1
f.function2
f.function3

instead of

myFuncation.function1
myFuncation.function2
myFuncation.function3

Thanks for the help.
 
K

Karl E. Peterson

red6000 said:
I have a module called myFunctions with many functions in it.

I then have a userform where I then call the functions.

To do this I am using:

myFunctions.nameOfFunction

Unless you have "nameOfFunction" as a public routine in multiple modules, that's
redundant. No need to preface it with the module name, at all.
is there a way I can define myFunctions in the user form to save me having
to keep typing it, ie I want to be able to code with:

f.function1
f.function2
f.function3

instead of

myFuncation.function1
myFuncation.function2
myFuncation.function3

No, can't do that, though you can drop the entire disambiguation if you care to.
 

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

Top