I figured that updating this was better than making a new post on the blog and linking them. Column A contains the text of the formulas (a preceding single quote does that), and column B contains actual function calls.Įnabling the Developer ribbon took a few moments when I got my own copy. Anyway, you can test these functions like that shown below. Make sure you do a custom installation and check Visual Basic for Application.
I think I found the trick to get Excel 2011 recognize and run User-Defined Functions. Hellowhom = 'Hello ' + CStr(nameIn) + '!'
