Category Archives: VBA

what Microsoft think VBA is good for …

Posted on 06/03/2013 by dougaj4

The front page of Excel for Developers now has a link entitled VBA, which takes you to: VBA for Excel developers which has a link entitled When to use VBA and why which says: There are three principal reasons to consider VBA … Continue reading →

Posted in Excel, UDFs, VBA | Tagged , , | 9 Comments

What is VBA good for? …

Posted on 25/02/2013 by dougaj4

… is the name of a Stackoverflow thread that sends a steady trickle of visitors here (thanks to a link posted by Charles Williams of FastExcel).  On a similar theme, Smurf on Spreadsheets has a post entitled “What’s so good … Continue reading →

Posted in Computing - general, Excel, VBA | Tagged , , , | 16 Comments

Using Frame4 for truss analysis

Posted on 21/02/2013 by dougaj4

The Frame4 spreadsheet is set up to allow the analysias of rigid-jointed 2D frames, but it is simple to use it for 2D truss analysis; simply either provide a moment release at each end of every member, or define every member … Continue reading →

Posted in Excel, Finite Element Analysis, Frame Analysis, Newton, VBA | Tagged , , , | 2 Comments

Function to make a list of functions …

Posted on 11/02/2013 by dougaj4

… and other procedures. I wanted to make a list of all the VBA procedures in a workbook, and discovered that Excel doesn’t have a built-in way of doing that.  People have written code to work their way around that of course, … Continue reading →

Posted in Arrays, Excel, UDFs, VBA | Tagged , , , , | 3 Comments

3DFrame v1.01

Posted on 03/02/2013 by dougaj4

The 3D frame analysis spreadsheet has been updated to v1.01, with a correction to the calculation of node reactions.  The previous version gave incorrect results for any restrained node at end 2 of any beam. Please download the new version … Continue reading →

Posted in Excel, Frame Analysis, Newton, VBA | Tagged , , , | 2 Comments