Animation Without Macros + more Excel tips

Excel Weekly News from Contextures December 16, 2014

In this week's Excel news, you'll see how to use a scroll bar, and no macros, to change a worksheet, and much more. Thank you for reading the Excel news, and I hope that you are enjoying the articles. If you have suggestions for future topics, please let me know.

This will be the last issue of the newsletter until January 5th, 2015, and I hope you enjoy the holiday season!

 -  Debra -

Select Multiple Items From List

Usually, you can only select one item from a drop down list, but with a bit of code, you can choose multiple items. To make this trick easier to use with a long list, you can use my latest sample file. It shows a popup form when you click on a cell, then you can select items from a listbox or combo box. Click OK, and all the selected items are entered in the cell..

Click here to see the details: Select Multiple Items From Long List

Excel Animation Without Macros

There are some situations where you can't use macros, or prefer not to, and you can accomplish some amazing things without them. For example, a few years agos, I built an animated Christmas tree, that changes when you move a worksheet scroll bar.

The technique uses VLOOKUP, conditional formatting, named ranges and a text box. You could do something similar on a business dashboard, to show sales results or other data.

Click here to get the details, and download the sample file: Scroll Bar Christmas Tree

You can see how it works, in the video below

More Excel Tips

Here are a few of the Excel articles that I read recently, that you might find useful:

Video: Scroll Bar Christmas Tree

Here is a short video that shows how the scroll bar Christmas tree works. The workbook doesn't have any macros -- just formulas, conditional formatting, named ranges, and a scroll bar.

Snowy Scenery

We had a busy week here at the Contextures headquarters. On Tuesday, I visited the local mall, and finished my Christmas shopping. Unfortunately, I also brought home a virus, and have the flu now. Next year, I'll do all my shopping online!

Thursday we had a snow storm, and in the photo below, you can see the view from our second storey. Friday, it was my in-laws' 70th anniversary -- an occasion that not too many people get to celebrate!

Featured Excel Product

I'm working on a new version of my PivotPower Premium add-in, and will release it in the next few weeks. If you buy the current vrsion, you will automatically get the update, when it is released, and you will avoid the price increase.

The PivotPower Premium add-in saves you time and effort, when working with Excel pivot tables. For example, you can quickly:

It makes a lovely Christmas gift too! ;-)

See more recommended Excel products.


Note: I am an affiliate for some of the products mentioned in this newsletter, and earn a commission on the sales.




Privacy Policy


Contextures Inc., Copyright 2019
All rights reserved.