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 - firstname.lastname@example.org
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
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
Here are a few of the Excel articles that I read recently, that you might find useful:
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.
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!
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:
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.
Contextures Inc., Copyright ©2017
All rights reserved.