To reference them in VBA, use the name of the .NET class library as shown in the previous example. For instance, if you create a class library named SalesComputations, refer to that name in your ...

Microsoft Excel can generate trend lines based on data you provide, and in doing do, calculates the equation of the trend line. This equation can be accessed using Excel's built-in Visual Basic tools.