• VBA Text Formatting And Font Formatting

    November 3, 2020 by

    Formatting text is one of the most powerful ways you can improve the adoption and usability of your Excel files. Excel has robust text formatting and font capability and these are available in VBA. Writing a macro that can insert text with certain text attributes and fonts or manipulate existing cells formatting can come handy… Read more

  • How To Build A Website

    November 2, 2020 by

    I’m sure there are a million articles on the internet about how to build a website. I was always curious about how to build my own website, especially after being a professional developer for a few years. My professional work always had me developing and iterating over existing pieces of work or working within an… Read more

  • D3 Network Graph Node Labels and Images

    October 13, 2020 by

    D3 is an amazing data visualization library that can be used to make any number of interactive data applications. I was recently working with the network graph, which is a visualization of nodes connected by lines to other nodes. The nodes can be dragged around and moved and you can specify parameters during the simulation… Read more

  • Form Controls: How To Use Them In Excel And VBA

    July 26, 2020 by

    One of the coolest things about Excel is the ability to add Form Controls. Form Controls are interactive UI elements you have probably seen many times. They can be: Command Buttons Combo boxes Checkboxes Form Controls are great because they are intuitive ways to interact with a piece of software that everyone can understand. Implementing… Read more

  • Excel VBA Sum Range Of Cells

    July 22, 2020 by

    Summing values is pretty simple in Excel with a spreadsheet and the SUM() function. You just set a cell to have a formula, ‘=SUM([Range]),’ and you can sum the values in any Range. But how can you the same in VBA? It took me a bit of digging to figure this one one, surprisingly. I… Read more

View all posts

Follow My Blog

Get new content delivered directly to your inbox.