Contextures Blog

Multiple Selection Drop Down With Codes

There is a sample file on my website that has VBA code for selecting multiple items from a data validation drop down list. You can insert all the selected items into the active cell, or down the adjacent column, or across a row. Today’s example shows how to make a multiple selection drop down with codes

Continue reading “Multiple Selection Drop Down With Codes”

Excel Roundup 20140120

If you’ve ever been disgruntled with your bank, you might enjoy Ben Orlin’s vision of how he would run a bank, on his Math With Bad Drawings blog. Instead of annual compounding, he’ll offer other options, such as:

Compounded Madoff-ly: After years of dubiously high interest, it will come out that I’m just typing random numbers into the spreadsheet.

Compounded sporadically: Your balance grows whenever I remember to update the spreadsheet.

Each option is illustrated with a bad drawing, like this one.

Your balance grows whenever I remember to update the spreadsheet. https://mathwithbaddrawings.com

Contextures Posts

Here’s what I posted last week:

Use a macro to link worksheet check boxes to specific cells, so you can track the responses.

Then, assign a macro to each check box, so it enters the current date when checked.

Change a pivot table layout to see which customers have not purchased your products.

Finally, for a humorous peek at what other people are saying about Excel, read this week’s collection of Excel tweets, on my Excel Theatre blog.

Upcoming Courses

No matter how long you’ve been using Excel, there’s always something new to learn.

Sign up for one or more of the free Business Analytics webinars offered in the 24 Hour PASS series, sponsored by Microsoft, Cisco and Dell. Topics inlclude: “Advanced Analytics in Excel 2013”, “Querying in DAX”, and”Predictive Analytics for Absolute Beginners”. The online sessions run on Feb 5th and 6th, and you can see the schedule here: 24 Hour PASS Schedule

Mynda Treacy’s Excel Dashboard course is open for registraion, and I highly recommend this online course, which has excellent content, and great student support from Mynda. Click the banner below, for more information.

What Did You Read?

If you read any other interesting Excel articles last week, that you’d like to share, please add a comment below.

Please include a brief description, and a link to the article.

__________________________________

Click a Check Box to Run a Macro

In the last post, we set up a To Do list with check boxes. Each check box is linked to a cell that’s 2 columns to the right, and we used a macro to set that up quickly. Now we’ll add code so we can click a check box to run a macro.

Continue reading “Click a Check Box to Run a Macro”

Link Check Boxes to Cells With a Macro

You can use check boxes on a worksheet, and link the results to a cell. If the box is checked, the cell shows TRUE, and if it’s not checked, the cell shows FALSE or the cell is empty. This makes it easy for someone to give a quick answer to a question, or select an option. You can even link check boxes to cells with a macro, so something happens automatically when the box is clicked.

Continue reading “Link Check Boxes to Cells With a Macro”

Excel Roundup 2014013

In The Guardian’s Data Blog column, where the tagline is “Facts are Sacred”, things took a less lofty turn last week. You can go back to the good old days in math class, where you entertained your friends by writing words on your calculator.

In the screen shot below, you can see the cheerful greeting from our Sharp Compet CS-1130 financial calculator. I’m not sure how old it is, but it’s probably from the 1980s, and still working well. Are you still using an old school calculator?

calculatorhello