How to perform a what-if analysis using a scrollbar control

Excel 2007
Excel 2003
Macros Excel 2007
Macros Excel 2003
Excel 2010
Home

You can perform a what-if analysis in an elegant manner by inserting a scrollbar control on your worksheet and changing a value in small increments that is linked to another calculation.
Watch the video below to see how this is achieved:




Reference

Home
Excel 2007 Excel 2003 Macros Excel 2007 Macros Excel 2003 Excel 2010