Excel Valentine Cards 2016

Excel Valentine Cards http://blog.contextures.com/

If you dread going into a crowded greeting card store this weekend, to shop for a Valentine's Day Card – you're in luck! You can make a card in Excel instead, and I'll show you two options.

Time spent in Excel is much more pleasant than time spent shopping, right?

Continue reading Excel Valentine Cards 2016

Excel Roundup 20160208

Excel Roundup http://blog.contextures.com/

In this week's roundup, find Excel help, new functions, Excel conferences, and much more.

Continue reading Excel Roundup 20160208

Change Excel VBA Code to Improve Speed

Popup List on Click or Double-Click http://blog.contextures.com/

In some of my files, macros run automatically when you select a cell on the worksheet. For example, if you've bought a copy of my Data Validation Multi-Select Premium (DVMSP) kit, it shows a pop-up list when you click on a cell with a drop down list.

I'll show you how to quickly change that, so the pop-up appears when you double-click, and you could make a similar change in other worksheet code.

Continue reading Change Excel VBA Code to Improve Speed

Excel Roundup 20160201

Excel Roundup http://blog.contextures.com/

In this week's roundup, formula challenge, better charts, fixing numbers, and much more.

Continue reading Excel Roundup 20160201

How to Fix Excel Numbers That Don't Add Up

Fix Numbers That Don’t Add Up http://blog.contextures.com/

If you download bank statement data into Excel, or copy numbers from a website, those numbers might not add up correctly. The bank data can look like numbers, but Excel sometimes sees those numbers as text -- not real numbers.

You can fix the numbers manually, as shown in the video below, or use a macro to automate the fix.

Continue reading How to Fix Excel Numbers That Don't Add Up

Excel Roundup 20160125

Excel Roundup http://blog.contextures.com/

In this week's roundup, Data Insights Summit, status bar messages, choose a chart, and much more.

Continue reading Excel Roundup 20160125

Show Message In Excel Status Bar

Show Message in Status Bar http://blog.contextures.com/

If a macro takes a long time to run, it can be frustrating to wait for it to finish. Usually the screen updating is turned off when a macro runs, so it's hard to tell if anything is happening. Maybe it stopped, and you'll be sitting here for the rest of the day, blissfully unaware of the problem.

To help you stay informed, you can show messages in the status bar, to let you know what progress is being made. It sounds like a technical challenge, but it's easy to do.

Continue reading Show Message In Excel Status Bar

Excel Roundup 20160118

Excel Roundup http://blog.contextures.com/

In this week's roundup, random numbers, big data, floating forms, chart labels and more.

Continue reading Excel Roundup 20160118

Excel Macro Buttons on Floating Form

Macro Buttons on Floating Form http://blog.contextures.com/

In the olden days (Excel 2003 and earlier), there were toolbars, and you could "float" those, and position them anywhere over the worksheet. You could also create custom toolbars, and add a few commands and macros to those. They could be moved around the worksheet too.

In the newer versions of Excel, those floating toolbars aren't available, but you can create something similar, based on a UserForm. Build your own, or download my example, and customize it.

Continue reading Excel Macro Buttons on Floating Form

Excel Roundup 20160111

Excel Roundup http://blog.contextures.com/

In this week's roundup, number formatting trick, pivot chart layout, spreadsheet comedy, and much more.

Continue reading Excel Roundup 20160111