using excel funtion in vba

[bestox]

i want to use the excel function "TEIL" in vba.
TEIL is out of the german version from excel and can be translateted into PART.

=TEIL("Hello World";3;7) in an excel-sheet delivers "llo Wor".

anyone has an idea, how i can use that function in vba?

thanks!

 

[sanrv1f]

you can use an excel function in VBA by qualifing it with "Application" keyword, like

Application.TEIL("Hello World";3;7)