Excel With VBA

How To Run Macro (VBA) When The Cell Value Changes?

In this post, you are going to find out how to detect when a cell value on your worksheet changes. So when my F7 value changes from “george” or blank to something else, a message box appears. Here is the code: Private Sub Worksheet_Change(ByVal Target As Range) Static blnDoneThis As Boolean Dim varOldValue As Variant… December 9, 2020

How To Parse JSON With Excel VBA?

I didn’t come up with this code, but it is pretty cool. It shows how to parse a JSON string with VBA. The impetus for this was to access the price data for various coins on coinmarketcap.com …and to get the price data for 50+ coins required getting a coinmarketcap api, and resulted in a… December 2, 2020

How To Load A Text File In Excel VBA With Load Data Infile?

So for reference sake, here is something easy. This is how to load a local text file into a variable, so you can process it. For example: So you have some JSON file, and you put the JSON formatted text locally in a text file so you can experiment on parsing it before you actually… December 2, 2020

How To Use VBA To Loop Through The Files In A Folder?

So, picture this…you have a client who just has the files in a folder illustrated by a picture, like a jpg. You need the file names from the picture, but you can use an OCR (Object Character Resolution) to list the files on the image because a lot of the text shows up like garbage.… November 3, 2020

How To Have VBA Parse A Name String?

This post was actually an answer to someone’s question on one of my videos from a few years back.