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.

Susan Harkins shows you two easy ways to populate an Excel UserForm, and neither requires a single bit of VBA code.

Learn how to use a data validation control to allow users to select when to run multiple VBA procedures in Microsoft Excel.