Search Contextures Sites
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 - email@example.com
- Select Multiple Items
- Animation Without Macros
- More Excel Tips
- Video: Scroll Bar Christmas Tree
- Weekly Photo: Snowy Scenery
- Featured Excel Product
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:
- The ModelOff 2014 Financial Modeling World Championship has ended, and the winner was 29-year-old Diarmuid Early, from Ireland.
- You can download the first chapter of Ben Jones' book, Communication Data with Tableau. The chapter is titled "Communicating Data", and the concepts can be applied to your work in Excel too.
- Charles Verdon uses Excel 2013 with the Power BI add-ins, to analyze data from a Facebook page.
- University students share their VBA projects, after taking a one semester course at Brigham Young University. There is a wide variety of topics, including Laser Tag, Murphy Bed Job Costing, and Forecasting Automation
- Last week, an Office update broke the ActiveX controls in Excel, and Jan Karel Pieterse shows how to fix the problem
- XOR LX shows how to create a unique, ordered list of most frequent numbers in a two-dimensional range, and admits that it's not the most straightforward solution.
- Finally, for a humorous peek at what other people are saying about spreadsheets, read the latest collection of Excel tweets, on my Excel Theatre blog. And vote for your favourite!
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:
- save and apply preferred pivot table settings
- format all the data fields at once
- change all the data fields from the Count function to the Sum function.
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 ©2014
All rights reserved.