Call Function by Name

Just wonder how to call the function if I have it's name in the variable String
for example something like that:

Please Login or Register  to view this content.

maybe there are some other ways?
Thank you for your help,
arbus

I completed your example to illustrate it better:

Please Login or Register  to view this content.

Originally Posted by raypayette

I completed your example to illustrate it better:

hi ray
I am not sure that I understood you
I used CallByName fucntion because there is such a fuction which executes a method of an object
So I thought maybe it can be used for calling a function if u have its name saved in the string variable

in my example I know that there is a function named "test" and I wanted to call that function
Imagine u have a list of similar finctions: test1, test2, test3 etc
you want to call them in the loop
so inside the loop u will assign a string variable name="test"+cstr(i) and afterfards u want to call the function with name="test"+cstr(i)

I tried to work out the glitches. For example result = "test" will not use the function test, rather it defines it as the string test; I correct3ed it to use the Boolean function "test". Also you redefined name as a text when it was a Boolean value; I corrected it.

Maybe you mean

Please Login or Register  to view this content.

Or in the worksheet

=test()

thats a brilliant idea, thanks!
what I wanted - to be able in the loop to generate string variables with function names (functions in the module already exist)
and afterwards to be able to call those functions (by their name stored in the string var) in the other module

imagine - I have a list of test functions named test1(), test2() etc
and I dont want to run all of them all the time
there is a config txt file with names of the function to be run

when macro is started it reads that file and has the list of names of the functions which I want to execute one by one

so the problem now is to run the existing function with a specified name
_________

the only solution found (thanks to rylo and royUK) (maybe not very elegant but perfectly working) is to use a temporary cell and print in it "=test1()" (if function name is "test1")
and to get the result of the function from that cell aftewards

so far I dont see how it can be done inside vbe only without using excell cells as a temporary storage of the result

Your example Function will be available whilst that workbook is open, because you actually set it to True. What is an example of a Function you ant to use?