The builder works fine for functions that you want to have on the worksheet itself, but if you try to call the function from VBA, you get an excel-generated error:
Compile Error: Sub for Function not defined
You can recreate the error by calling "testSub" in the worksheet "TEST.xls" or by trying to execute the function in VBA. The Add-in that I created for this is contained in the "distrib" subfolder.
Best Answer