Author Archives: Marcus

How to turn Excel into a Vespa

The head of the 5-member PMO team at this mid-size bank was exasperated.She needed a simple solution for her small team to monitor & report the costs of projects within the department. A single Excel workbook, by itself, wasn’t suitable for a team of five.She reached out to the head of IT development for a […]

Continue reading

So why (the heck) is VBA still being used in Excel?

Here’s a common scenario I witness frequently, particularly in finance:A business manager approaches their IT Department in need of a solution.  Maybe there’s been a regulatory change, or they have a manual process which has inherent operational risk, or there’s a new product they want to trade.The IT Manager says “Sure, we can have something […]

Continue reading

Coding VBA on the Dark Side

Have you ever wanted to change the colour scheme or theme of Excel’s Visual Basic Editor? Read on to find out how and start coding on the Dark Side.Coding VBA on the Dark Side If you’ve been coding in any modern Development Environment, you may know that many of them come with colour schemes. A […]

Continue reading

Why learn VBA when I can just use the Macro Recorder?

Why learn VBA when I can just use the Macro Recorder? What are the limitations of recording a macro in Excel rather than writing VBA code? The VBA macro recorder in Excel is indeed a handy-dandy tool.For a beginner, it’s a useful place to start learning about VBA. Even for seasoned VBA developers it’s handy to […]

Continue reading

Recording the history of a cell’s value

Here’s the situation. You’ve got a spreadsheet where you’d like to track the changes to some cell values over time. Maybe they’re stock prices, or exchange rates or input parameters to a model. Whatever. But when you change the value tomorrow, you want a record of what that value was last week.The Curse of Excel’s Track Changes FeatureThe first […]

Continue reading

Getting Data from a Website in JSON format using VBA

One increasingly common task for Excel users is to retrieve data from the internet.
Simply, retrieving data from the web is the first challenge.
This sounds simple enough (and as you’ll soon see, it is).
But most people run into a roadblock with the second challenge: wrestling with data in JSON format.
Discover the easiest and fastest way to get JSON data into Excel.

Continue reading

Speed Up Data Entry in Excel with Prompts

Have you ever created a spreadsheet people used to enter data? A bit like a data entry form, but on a worksheet?You may have wondered how to make the form more intuitive. That way your users knew what they should enter in each field.If that’s the case, this post is for you.Making Data Entry More […]

Continue reading