Skip to content

Excel VBA Tutorial

Convert Numbers into Words in Microsoft Excel – With or Without Currency | VBA Included in Download

    In this Microsoft Excel video tutorial I explain how to convert numbers into their words equivalent. You can do this using a VBA custom function. A version of this function is available on Microsoft’s website: https://support.microsoft.com/en-us/office/convert-numbers-into-words-a0d166fb-e1ea-4090-95c8-69442cd55d98 I found this version of the function, although very good, had some spacing and wording issues; it also only… Read More »Convert Numbers into Words in Microsoft Excel – With or Without Currency | VBA Included in Download

    Show / Hide Rows or Columns Based on Drop-Down Selection | Pick Table From Drop-Down List

        In this video tutorial I demonstrate how to show/hide rows or columns or tables based on a drop-down list selection. This particular technique requires VBA code which I supply via the link above. Click here to download the featured file (including code). Video Table of Contents 00:00 – Introduction 00:49 – Create the data… Read More »Show / Hide Rows or Columns Based on Drop-Down Selection | Pick Table From Drop-Down List

      Find & Replace Multiple Words or Characters at Once in Excel | 3 Methods VLOOKUP, SUBSTITUTE, VBA Macro

        In this video I demonstrate how to find and replace multiple words at once in Excel. I explore three methods that can be used to achieve this. Click here to download the featured file Video Table of Contents 00:00 Introduction 00:44 METHOD 1: Use VLOOKUP or XLOOKUP for whole word find and replace Here’s the… Read More »Find & Replace Multiple Words or Characters at Once in Excel | 3 Methods VLOOKUP, SUBSTITUTE, VBA Macro