Mindblown: a blog about philosophy.

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…

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…

This post is actually in response to an Excel VBA question. Basically it can be summarized by titling it “automatic invoice number generator excel” That is what this is: This can be filled out with user form, but all the data ultimately gets entered into the underlying spreadsheet so we’ll skip the user form part…

Here’s an example of how to check if a value exists in a range of cells: It is actually a response from a question I received: “Can you let me know how to check if a particular value is present in a named list. Or in a different worksheet” You can use the “countif” function.…

In response to a comment on my Youtube video: https://www.youtube.com/watch?v=Z9kt86I_rq0&feature=em-comments *This gives an example of how to get notified of a change made to one of the worksheet cells. Private Sub Worksheet_Change(ByVal Target As Range) Static blnDoneThis As Boolean Dim varOldValue As Variant Dim varNewValue As Variant ‘initialize a variable to regulate the Worksheet_Change event…

I had another interesting question involving copying and pasting some values over 1500 rows so I generated the code in VBA and decided to post it here. Here is the “pseudocode” (my though process, which you should do in order to structure your thoughts): 1. loop through the cells 2. select c13:L16 -> copy 3.…

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.…

This post actually was birthed from a comment made on one on my Youtube videos: I wanted to know as how to trigger an event when a cell value is deleted? (a comment to this post’s video: http://www.vbastring.com/blog/how-to-run-a-macro-when-cell-value-changes-in-excel-vba/) So we are going to trigger an Excel VBA event when a value is deleted from a…

This post was actually an answer to someone’s question on one of my videos from a few years back. https://www.youtube.com/watch?v=UspqR0g4XyU The comment was: How would you do this for the last name? Or second last name? How to find the space after the first space, and the space after the second space? And then, if…