Available Functions to VBA

%3CLINGO-SUB%20id%3D%22lingo-sub-2721409%22%20slang%3D%22en-US%22%3EAvailable%20Functions%20to%20VBA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2721409%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Everyone!%3CBR%20%2F%3E%3CBR%20%2F%3EIs%20there%20any%20tool%20that%20helps%20to%20convert%20Functions%20that%20already%20exist%20to%20VBA%20code%20that%20you%20can%20watch%3F%3CBR%20%2F%3EI%20am%20trying%20to%20find%20the%20code%20of%20%22%3CSPAN%3ESERIESSUM(x%2C%20n%2C%20m%2C%20coefficients)%22%20but%20without%20success.%3CBR%20%2F%3E%3CBR%20%2F%3EThank%20you%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2721409%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2721450%22%20slang%3D%22en-US%22%3ERe%3A%20Available%20Functions%20to%20VBA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2721450%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1147088%22%20target%3D%22_blank%22%3E%40AvivSH%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EMost%20(but%20not%20all)%20worksheet%20functions%20have%20an%20equivalent%20in%20VBA%20as%20methods%20of%20the%20Application.WorksheetFunction%20object.%3C%2FP%3E%0A%3CP%3ESee%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Foffice%2Fvba%2Fapi%2Fexcel.worksheetfunction%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EWorksheetFunction%20object%20(Excel)%3C%2FA%3E%20and%20in%20particular%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Foffice%2Fvba%2Fapi%2Fexcel.worksheetfunction.seriessum%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EWorksheetFunction.SeriesSum%20method%20(Excel)%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EBut%20you%20cannot%20see%20the%20inner%20workings%20of%20the%20functions.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi Everyone!

Is there any tool that helps to convert Functions that already exist to VBA code that you can watch?
I am trying to find the code of "SERIESSUM(x, n, m, coefficients)" but without success.

Thank you

1 Reply

@AvivSH 

Most (but not all) worksheet functions have an equivalent in VBA as methods of the Application.WorksheetFunction object.

See WorksheetFunction object (Excel) and in particular WorksheetFunction.SeriesSum method (Excel) 

 

But you cannot see the inner workings of the functions.