Search Contextures Sites

 

Contextures
Newsletter Index

 

Contextures
Excel news
by email

 

 

 

Excel UserForms for Data Entry

 

30 Excel Functions in 30 Days

 

 

Contextures News

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 -  ddalgleish@contextures.com

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:

  • 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 
  • 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!

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:

  • 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.

It makes a lovely Christmas gift too! ;-)

________________________

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

 

Learn how to create Excel dashboards.

 

Privacy Policy

 

Contextures Inc., Copyright 2014
All rights reserved.