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 readingWhy 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 readingRecording 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 readingGetting 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.
Why does excel sometimes get stuck on a group of cells
“Why does excel sometimes get stuck on a group of cells?””Why does excel sometimes get stuck on a group of cells and it’s very hard to get it to click and sit on only one cell at a time?”This was a question I answered on Quora.It’s something which has plagued me in the past, so […]
Continue readingSpeed 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