Category Archives: VBA

VBA code generation on the spreadsheet

Posted on 07/02/2012 by dougaj4

A previous post looked at using VBA to generate more VBA code.  This post looks at automatic code generation on the spreadsheet, which may be transferred into the a VBA project using the techniques discussed in the earlier post, or simply … Continue reading →

Posted in Arrays, Excel, Finite Element Analysis, Newton, UDFs, VBA | Tagged , , , , , | Leave a comment

Retrieving unique values from a range or array …

Posted on 31/01/2012 by dougaj4

… using the Scripting Dictionary object. in a previous post I looked at using the dictionary object to count connected elements in a finite element model.  This post looks at a more general (and simpler) usage to return unique values from … Continue reading →

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

The Switch Function (VBA and UDF)

Posted on 27/01/2012 by dougaj4

Switch is a VBA function that operates in a similar way to the Select Case statement.  The function arguments are a series of pairs of values, the first of each pair being an expression that can be evaluated as TRUE … Continue reading →

Posted in Excel, Geotechnical Engineering, Newton, UDFs, VBA | Tagged , , , , | 9 Comments

LatPilePY 1.03

Posted on 27/01/2012 by dougaj4

The LatPilePY spreadsheet has been updated with detailed corrections to the function for generating PY curves.  The updated version can be downloaded from LatPilePY.zip. See LatPilePY 1.02 for more details of the spreadsheet content and background.

Posted in Excel, Geotechnical Engineering, Newton, UDFs, VBA | Tagged , , , , , | 5 Comments

LatPilePY 1.02

Posted on 23/01/2012 by dougaj4

Following some discussion at Eng-Tips and elsewhere I have updated the LatPilePY spreadsheet, previously presented at Lateral pile analysis with PY curves …  This spreadsheet provides User Defined Functions (UDFs) to carry out the analysis of vertical piles under lateral loading, … Continue reading →

Posted in Concrete, Excel, Geotechnical Engineering, Newton, UDFs, VBA | Tagged , , , , , , | 3 Comments