Array SortAlpha
Sorts arrays alphabetically, ascending or descending.
Original Author: Andy Slowey
Inputs
Array and Sort order
Assumptions
Okay so this isnt that complicated but it is a rather old bit of code I dug up while clearing out an old hard drive. I do have a versionfloating about someplace that does multidimensional arrays which will follow when I find it!
Returns
Array
API Declarations
Copyright... Dont be stupid!
Code
Public Function IsNullEx(ValueToCheck As Variant, varWhatToReturnIfNull) As Variant
If IsNull(ValueToCheck) Then
IsNullEx = varWhatToReturnIfNull
Else
IsNullEx = ValueToCheck
End If
End Function
Usage example:
txtClientName = IsNullEx(rst!ClientName, "unknown")
Loading Comments ...
Comments
No comments have been added for this post.
You must be logged in to make a comment.