ICAEW.com works better with JavaScript enabled.

VBA and macros

View a list of articles and webinars produced by the Excel Community on VBA and macros.

Displaying 1-20 of 72 results
Simon Hurst
Exclusive Excel’s real-life superpowers
  • Article
  • 24 Oct 2024
  • Simon Hurst
Useful as some features are when used in a spreadsheet, they could be even more empowering if available in real-life. In this article we consider some examples and explore the use of AI in illustrating the possibilities.
Ruth Butler-Lee
Exclusive EXCEL TIP OF THE WEEK Excel Tips & Tricks #493 - How to add a custom ribbon to your workbook part 2
  • Article
  • 14 Aug 2024
  • Ruth Butler-Lee
This week, we have a developer level post which explores how to set up your custom ribbon with tailored buttons.
Headshot of Mark Proctor
Exclusive Office Scripts vs VBA: What’s the difference?
  • Article
  • 13 Feb 2024
  • Mark Proctor
Office Scripts are a new scripting language for automating Excel. In this article, Mark Proctor explores how Office Scripts differ to VBA and what we can or cannot do with each.
Ben Ducker
Exclusive YOUR QUESTIONS ANSWERED Your Questions Answered #6 – Financial Modelling and Scenario Planning continued: What are your thoughts on incorporating macros into models?
  • Article
  • 31 Jul 2023
  • Ben Ducker
In a recent webinar on 'Financial Modelling and Scenario Planning: Mastering Effective Decision-Making', Craig Stirk and Ben Ducker explored why scenario planning is important and why structured models can help. Ben returns to answer some questions from the webinar they were unable to respond to during the session.
Headshot of Bani Lamba
Exclusive EXCEL TIP OF THE WEEK TECH NEWS Excel Tips & Tricks #470 – Introducing Office Scripts in Excel
  • Article
  • 28 Apr 2023
  • Bani Lamba
Hello and welcome back to Excel Tips and Tricks! This week we have a Developer level post where provide a high-level overview of Office Scripts in Excel, a potential replacement for VBA to help automate tasks.
Simon Hurst
Add-ins or bad-ins? The dangers of Excel XLL files.
  • Article
  • 02 Feb 2023
  • Simon Hurst
Most Excel users know about the dangers of running macros received from an untrusted source. However, as Microsoft strengthens its security procedures relating to macros, the danger might increasingly come from another direction: Excel add-ins and, in particular, .XLL files.
Headshot of Ian Pay
Exclusive TECH NEWS EXCEL TIP OF THE WEEK Excel Tips and Tricks #454 – Revisiting splitting workbooks with VBA
  • Article
  • 13 Sep 2022
  • Ian Pay
A Developer level post in which we are going to work through the VBA code required to take a workbook and cut it into one file for each sheet, and save all the resulting files.
Exclusive Getting started with VBA
  • Webinar
  • 22 Nov 2021
John Tennent draws back the curtain and shows you how to get started with this powerful Excel tool.
David Lyford-Smith
Exclusive EXCEL TIP OF THE WEEK TECH NEWS Excel Tip of the Week #419 - Revisiting macros and custom functions
  • Article
  • 09 Nov 2021
  • David Lyford-Tilley
Hello all and welcome back to the Excel Tip of the Week! This week, we have a Developer post in which I am sharing some of my frequently-used macros and custom functions with you all.
EXCEL TIP OF THE WEEK TECH NEWS Excel Tip of the Week #414 - Select Case and stamp duty revisited
  • Article
  • 05 Oct 2021
  • David Lyford-Tilley
This week, we have a Developer post in which we’re looking at a VBA coding option for situations where we have multiple paths to go down – Select Case. We’re going to be comparing and contrasting this with the more common If-Then-Else structure, which we covered back in TOTW #141. We’ll use the same example we did back then: stamp duty land tax.
EXCEL TIP OF THE WEEK TECH NEWS Excel Tip of the Week #410 - Installing VBA redux
  • Article
  • 07 Sep 2021
  • David Lyford-Smith
Hello all and welcome back to the Excel Tip of the Week! This week, we have a Developer level post in which we are making a definitive review of how to install VBA macros and user-defined functions in your Excel – even if you don’t know any VBA yourself.
Exclusive EXCEL TIP OF THE WEEK Excel Tip of the Week #400 - VBA case study - Exhausting a question bank
  • Article
  • 23 Jun 2021
  • David Lyford-Smith
This week we have a Developer-level post in which we are going to take a particular complicated scenario we want to model, and we’re going to use it to get deeper into understanding how loops and variables can help us when we’re working in VBA.
John Yeldham
TECH NEWS INTRODUCTION TO FINANCIAL MODELLING Intro to Financial Modelling - Part 13: VBA
  • Article
  • 25 Feb 2021
  • John Yeldham
It is a common request among those that aspire to be great modellers, that they want to "learn" VBA. But just as knowing your debits and credits doesn't make you good at business, knowing VBA doesn’t make you good at modelling. It is more difficult, but more useful, to learn how to structure your models to reduce or eliminate the need for VBA altogether.
David Lyford-Smith
Exclusive EXCEL TIP OF THE WEEK Excel Tip of the Week #382 Keeping your VBA code readable
  • Article
  • 23 Feb 2021
  • David Lyford Smith
Hello all and welcome back to the Excel Tip of the Week! This week, we have a Developer post in which we’re going to look at a sort of meta-topic to accompany our ongoing exploration of VBA – specifically, how to keep your VBA code readable.
Exclusive EXCEL TIP OF THE WEEK TECH NEWS Excel Tip of the Week #374 - VBA case study: Reordering worksheets
  • Article
  • 22 Dec 2020
  • David Lyford-Smith
In this article we return to our occasional series exploring the possibilities of VBA. This time we are looking at some tools for working with worksheets – how to list them, and how to rearrange them. This is a particularly handy set of tools whenever working with a larger workbook, as the in-built Excel options for reordering your worksheets are quite limited.
EXCEL TIP OF THE WEEK Excel Tip of the Week #370 - VBA case study: Making an advent calendar
  • Article
  • 01 Dec 2020
  • David Lyford-Smith
This week, we have a Developer level post in which we’re going to explore some more VBA coding – through the medium of creating an automated template for creating an advent calendar.
David Lyford-Smith
INTRODUCTION TO FINANCIAL MODELLING Intro to Financial Modelling - Part 11: Clarity and Named Ranges
  • Article
  • 19 Nov 2020
  • David Lyford-Tilley
In this instalment of our continuing blog series on the ICAEW’s Financial Modelling Code, Alistair Hynd, partner at RSM, and his colleague Brandon Maysey explore the main principles behind named ranges: how and when to use them; key points to consider when creating a named range; and how these principles can be extended to VBA when creating macros.
Exclusive EXCEL TIP OF THE WEEK Excel Tip of the Week #359 - Audit sampling templates: VBA
  • Article
  • 15 Sep 2020
  • David Lyford-Smith
This week we are concluding our three-part series examining different methods for building an audit sampling template with a Developer level post, working on solving the problem with VBA code.
EXCEL TIP OF THE WEEK TECH NEWS Excel Tip of the Week #353 - Audit sampling templates: Dynamic arrays
  • Article
  • 04 Aug 2020
  • David Lyford-Smith
A Creator-level post in which we kick off a new mini-series. In this mini-series we will be showing how you can build a template to do audit sampling in three different ways - with traditional Excel formulas, with VBA macros, and today's topic - how to build the template with the new dynamic arrays available in Excel for Microsoft 365.
Exclusive EXCEL TIP OF THE WEEK Excel Tip of the Week #347 - VBA case study: Filtering visible sheets
  • Article
  • 23 Jun 2020
  • David Lyford-Smith
This week, we have a Developer level post in which we are going to take a walk through how to write a small VBA routine for a task that's otherwise impossible to do in Excel - namely, quickly filtering which sheets in a workbook are visible and which are hidden. This is useful e.g. if you have a master workbook for computations, but specific users only need to fill in certain parts.
Displaying 1-20 of 72 results

Search the Excel Community archive

This archive of Excel Community content from the ION platform will allow you to read the content of the articles but the functionality on the pages is limited. The ION search box, tags and navigation buttons on the archived pages will not work. Pages will load more slowly than a live website. You may be able to follow links to other articles but if this does not work, please return to the archive search. You can also search our Knowledge Base for access to all articles, new and archived, organised by topic.

Search the archive Access the knowledge base
Excel polaroid