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 76 results
Lego graph image
A beginner's guide to automating in Excel using Office Scripts
  • Webinar
  • 26 Nov 2024
  • ICAEW Excel Community
Office Scripts is a feature that allows users to automate repetitive Excel tasks.
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.
David Lyford-Smith
TECH NEWS EXCEL COMMUNITY ROUND UP Excel Community round-up - November 2021
  • Article
  • 02 Dec 2021
  • David Lyford-Tilley
Here are all the new Excel articles and webinars from the Excel Community in November 2021. Posts marked as public can be accessed by anyone; other articles are accessible to Excel Community & Tech Faculty subscribers and can be accessed by logging in to your ICAEW account.
Lego graph image
Exclusive Getting started with VBA
  • Webinar
  • 22 Nov 2021
  • Excel Community
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.
David Lyford-Smith
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.
David Lyford-Smith
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.
David Lyford-Smith
Exclusive EXCEL TIP OF THE WEEK TECH NEWS Excel Tip of the Week #409 - Controls redux
  • Article
  • 31 Aug 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 making a comprehensive review of the various controls which you can use to drive your Excel spreadsheets – from Form controls to ActiveX controls, and a few other pieces besides.
David Lyford-Smith
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.
Jonelle Johnson-Turner
INTRODUCTION TO FINANCIAL MODELLING Intro to Financial Modelling - Part 15: Error reduction - Common pitfalls
  • Article
  • 19 Apr 2021
  • Jonelle Johnson-Turner
In this ICAEW modelling good practice blog instalment, I will be examining basic good practice for calculation techniques, as covered in page 16 of the Financial Modelling Code.
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.
David Lyford-Smith
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.
David Lyford-Smith
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.
Displaying 1-20 of 76 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