How to Use VBA to Access the Equation of a Trend Line on Microsoft Excel. Trend lines are a type of regression analysis, which is a way to study the relationships between variables.