Use Excel Scroll Bar to Trim Christmas Tree

An Excel scroll bar can be used for practical (and sometimes boring) things, like testing the effect of price changes, or adjusting a chart’s date range. But this is the festive season, so let’s use a scroll bar for something more, well, festive!

Trim the Tree

In this example, instead of accounting and finance, you’ll see how to use an Excel scroll bar to decorate a Christmas tree, without macros. Unfortunately, it can’t make hot chocolate or eggnog, so you’ll need to provide your own.
It’s not just for the holiday season though — the sample file has useful features that you can adapt to other workbooks too:

  • Scroll bar lets users change a number quickly and easily
  • A text box that displays a changing message based on VLOOKUP formula
  • conditional formatting shows hidden cells when target number is reached
  • named ranges make it easy to work with specific cells

scrollbartree00

Watch the Video

To see how the tree trimming scroll bar works, you can watch this short Excel video.
Video Link on YouTube:  http://www.youtube.com/watch?v=6UCJCB2vtHA

Excel Scroll Bar Sample File and Instructions

For instructions on creating the Excel scroll bar file, and to download the sample file, please visit the Contextures website: Excel Scroll Bar Christmas Tree Example.
_______________