In Passing complex arguments with default values in VBA Bruce Mcpherson isn't sure if you can use named arguments in custom functions.
Continue Reading »
A Treatise on Types of VBA Procedures
To support modular programming, at least three different types of VBA procedures should be recognized. I'll call them first-level, second-level and third-level procedures to distinguish them. I humbly put these concepts forward as best practice (if they weren't already). Let's take some time to discuss the difference.
TimezoneDb API returns time zone information
TimezoneDb has an API which returns time zone information about a geographical point (latitude/longitude).
It requires an API key, which you can sign up for using the above link. I have an API key but have removed it for this example. In this article we'll review how to access the API using VBA. I've created a function which can be used on the worksheet (as a UDF) and also in VBA.
Continue Reading »
Follow Me