Entisoft Tools 2.0 Code Library

Search and browse all 1,823 documented Visual Basic & VBA functions, properties, subroutines, and data structures across 57 class modules (v2.1 Build 208).

Reset
Curated Highlights

Top 20 Most Useful Functions

AgeDifference
DatesTimes Class
Return the difference in years between the two dates. vCountTime determines whether Time is considered within the calculation.
★ Top 20 Function
ConvertMeasure
Units Class
"Convert Measurement" Convert a measurement to some other type of measurement. For example, convert 1/5 ft/s (feet per second) to mph (miles per hour).
★ Top 20 Function
DictionaryOrder
StringWords Class
Return a string representing the dictionary order of the string vValue. If the string begins with any of the words in vRotateWords, those words are moved to the end of the string.
★ Top 20 Function
DirToVariantVector
FileNames Class
"Directory To Variant Vector" Reads the list of files in a directory into a one-dimensional array of Variant values. Optionally includes the names of files in all subdirectories. Function returns True upon success and False upon failure.
★ Top 20 Function
FileLinesLikeToString
Utilities Class
Returns a string containing the lines of a text file which match some pattern. Returns empty upon failure.
★ Top 20 Function
FillText
FormatsJustifies Class
Spreads out the words of a string so that the string length is exactly vWidth.
★ Top 20 Function
FixUpVariantToStringSub
FixUps Class
"Fix Up Variant To String Subroutine" Leave string values as-is, and convert numeric or date arguments into string values. Assign the default value vDefault to the argument rArgument if conversion is not possible.
★ Top 20 Sub
HashString
StringManipulations Class
Return a hash value for the specified string. Converts a string into a numeric identifier that is likely unique, given an appropriate value for vRangePrimeNumber. The number returned will be between 0 (zero) and vRangePrimeNumber - 1.
★ Top 20 Function
InStrCharacters
StringSearches Class
"In String Characters" Return the first position within string vLine of any of the characters within vFindChars.
★ Top 20 Function
Logarithm
MathTrigComplex Class
Natural logarithm of a complex or real number.
★ Top 20 Function
RandomString
RandomValues Class
Returns a random string whose length is between vMinLength and vMaxLength characters inclusive and which will be composed of the characters in string vAlphabet.
★ Top 20 Function
ReplaceString
StringReplacements Class
Perform string replacement. Replace all non-overlapping occurrences of vFind in vLine with vReplace.
★ Top 20 Function
SeparatePathAndFile
FileNames Class
Separate a path name like "C: \WINDOWS\USER.EXE" into its Path ("C:\WINDOWS") and Name ("USER.EXE") components. Remove the last path separator "\" unless it immediately follows the drive separator ": ". Function returns True upon success and False upon failure.
★ Top 20 Function
SortVariantMatrixRows
ArraySorts Class
Non-recursive Quick Sort of the elements of a two-dimensional variant array. The column comprising the sort key is passed in vKeysInDim1(1..UBound).
★ Top 20 Function
SpellCurrency
Spellings Class
Accepts a number representing currency, and returns the value spelled-out in US English or UK English words.
★ Top 20 Function
StringToClipboard
BasicExtensions Class
Place a String onto the Windows Clipboard as Text.
★ Top 20 Function
StringToVariantVector
ArrayConversions Class
Parse a delimited string into a one-dimensional array of Variants. Parse a string representing one row of delimited text, placing each column value into one array element.
★ Top 20 Function
StripVBComments
StringExtras Class
"Strip Visual Basic Comments" Strip the comments from a string representing a line of Visual Basic code. Returns a string containing everything but the comment portion of a line of Visual Basic source code.
★ Top 20 Function
VBObjectBrowserInfoAdd
VBUtilities Class
"Add Visual Basic Object Browser Information" Build the help for a Visual Basic Class, Form, or Module from the Comments.
★ Top 20 Function
WrapText
FormatsJustifies Class
Wrap the lines of text within each paragraph so that each line is no longer that the specified maximum width.
★ Top 20 Function