Evaluate Function - update

Previous post
The evaluate function described in the previous post has been used in writing a UDF that will evaluate the integral of any suitable function over a specified range.
The revised worksheet can be downloaded from:
Eval.zip

Drawing in Excel-3

Previous post
OK, here are some of the promised basics of using VBA to create drawings in Excel.
This and following posts will cover:

The shape objects and how to create them
How to select, group, and delete shapes
How to modify existing shapes
How to get the properties of existing shapes
How to scale shapes
How to create 3D perspective wireframe drawings

There [...]

Importing text files with VBA - 3

The text import file has been modified to split large files into one or more ranges.
The maximum number of rows for each range is specified, together with a sufficient number of valid range names, which may be on the same sheet or different sheets. The modified file has been tested with a text file with [...]

Drawing in Excel - 2

Before getting down to basics, the attached file:
Animation demo
Illustrates how Excel shapes can be simply animated.
Screen shot:

The code for the animation (having previously drawn a circle and a rectangle with no fill, and noted their names):

Sub Animate()
Dim Start As Single, xInc As Single, yInc As Single, OvlWidth As Single, OvlHeight As [...]

Reinforced Concrete Section Analysis - 4

Previous post
The spreadsheet presented in the previous post in this series uses the basic equation given below to find the location of the neutral axis:
For a cross section with any applied axial load at eccentricity e, measured from the compression face, and depth of the neutral axis X below the compression face:
INA = QNA(X + e)
Where QNA [...]

Importing text files with VBA - 2

Previous post
The text file import routines and functions presented in the previous post have been modified with the following additions:
Lines of text can be split into separate cells, at any designated character (e.g. a coma or a space)
The SplitText function can also be used as a UDF, to split lines of text previously imported.  In [...]

Drawing in Excel - 1

This is a the first of a series of posts describing how to produce scale drawings in Excel, based on a list of coordinates. This post will cover the use of XY graphs, or scatter charts as Microsoft likes to call them. Later posts will cover the use of the various line and shape objects, [...]

Reinforced Concrete Section Analysis - 3

Previous post -1
Previous post -2
The theory presented in the previous 2 posts in this series has been incorporated into an Excel UDF, allowing concrete and reinforcement stresses and strains to be evaluated quickly and easily for reinforced and prestressed members of complex cross-section, subject to combined bending and axial load.
The Excel file also includes UDFs [...]

Worksheetfunction vs UDF - 2

Previous Post
In a recent post at microsoft.public.excel.programming Charles Williams (Decision Models) found that a VBA User Defined Funcion (UDF) searching through a defined range for a specified number was very much slower than simply using .worksheetfunction.match as below:
Function VBAMatch2(arg As Double, XRange As Variant) As Long
    VBAMatch2 = Application.WorksheetFunction.Match(arg, XRange, 1)
End Function
I found this strange, [...]

Importing text files with VBA

Importing data from other programs into an Excel spreadsheet, in the form of text files, is a frequent requirement in engineering and scientific applications.  Often the data will have been formatted to suit printed output and will require processing before importing into the spreadheet.  In addition to rather cumbersome procedures, the built-in Excel facilities for [...]