Precision Developer Libraries & Software Craft.
Explore the complete interactive reference for Entisoft Tools 2.0 (1,823 documented Visual Basic & VBA functions across 57 class modules), our award-winning Pocket Tablet™ pen utility, and the original Entisoft Units engine that grew into ConvertIt.com.
Add a new definition ( Key and Item pair) into the hash table or update an existing Key and Item pair. Inserting an Item with the same Key as another Item in the table causes the previous Item to be overwritten.
Public Function AddOrUpdate( _
ByVal vKey As Variant _
, ByVal vItem As Variant _
) As Boolean
Assuming
Dim htTemp As New HashTable
for example
htTemp.AddOrUpdate "FunctionName", 23
htTemp.AddOrUpdate "FunctionName", 24
leaves
htTemp.Count = 1
"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).
Public Function ConvertMeasure( _
ByVal vFromValue As Variant _
, ByVal vFromUnits As Variant _
, ByVal vToUnits As Variant _
) As Variant
ConvertMeasure(5, "feet", "meters")
Return the difference in years between the two dates. vCountTime determines whether Time is considered within the calculation.
Public Function AgeDifference( _
ByVal vFromDate As Variant _
, ByVal vToDate As Variant _
, Optional ByVal vCountTime As Variant _
) As Variant
AgeDifference(#1/1/70#, #1/1/96#) = 26
AgeDifference(#1/1/70#, #5/1/96#) = 26
AgeDifference(#9/1/70#, #5/1/96#) = 25
AgeDifference(#1/1/70 9:00#, #1/1/96 5:00#) = 26
AgeDifference(#1/1/70 9:00#, #1/1/96 5:00#, True) = 25
Accepts a number representing currency, and returns the value spelled-out in US English or UK English words.
Public Function SpellCurrency( _
ByVal vDollars As Variant _
, Optional ByVal vSpellTheCents As Variant _
, Optional ByVal vUSEnglish As Variant _
) As Variant
SpellCurrency(34.23, False) = "Thirty-four and 23/100 Dollars"
SpellCurrency(34.23, True) = "Thirty-four Dollars and Twenty-three Cents"
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.
Public Function HashString( _
ByVal vValue As Variant _
, Optional ByVal vRangePrimeNumber As Variant _
) As Variant
HashString("Hello") = 14802676
HashString("Hello", 4093) = 83
HashString("World") = 10825270
HashString("World", 4093) = 1445
Calculates the number of days within the coupon period that includes the coupon date. That is the number of days between the previous coupon date and the next coupon date.
Public Function CouponDays( _
ByVal vSettlement As Variant _
, ByVal vMaturity As Variant _
, ByVal vFrequency As Variant _
, Optional ByVal vBasis As Variant _
) As Variant
CouponDays(#1/15/96#, #12/31/99#, 1, US_NASD_30_360) = 360
CouponDays(#1/15/96#, #12/31/99#, 2, US_NASD_30_360) = 180
CouponDays(#1/15/96#, #12/31/99#, 4, US_NASD_30_360) = 90
CouponDays(#1/15/96#, #12/31/99#, 1, Actual_Actual) = 366
CouponDays(#1/15/96#, #12/31/99#, 2, Actual_Actual) = 182
CouponDays(#1/15/96#, #12/31/99#, 4, Actual_Actual) = 91
The Entisoft Ecosystem
From Visual Basic's Swiss-army-knife standard library and Pocket PC pen computing to today's live web platforms.
Entisoft Tools 2.0 Pro
Over 1,500 hardcore functions and classic data structures — Hash Tables, Stacks, Deques, Sparse Arrays, Financial & Statistical math, String algorithms, Ciphers, and Windows APIs — seamlessly integrated into Visual Basic & Microsoft Office VBA.
Powered by SourceLink Technology: automatic static dependency analysis that extracts only the routines your project uses directly into source code, eliminating DLL distribution.
Pocket Tablet™
The original active pen digitizing tablet that put docked Pocket PCs to work — bringing natural pen drawing, Office XP handwriting recognition, and cursor control to Windows desktops via ActiveSync or Wi-Fi.
5 Cows Rated
PPC 2002 Nominee
Entisoft Units → ConvertIt.com
Born in 1996 as a natural-language measurement calculator for Windows, Excel, and Access recognizing 800+ SI, metric, Imperial, historical, and ancient measures (like converting "45 ft*lbs/second^2" directly to newtons). Today that engine powers ConvertIt.com.
Entisoft Extra → PlacesNamed.com
Originally built as a cross-referenced hypertext atlas of countries, area codes, states, and world geography. That vision grew into PlacesNamed.com — now a modern .NET 10 + SQL Server atlas indexing 204,000+ cities, census names, maps, and statistics.
Browse All 57 Class Modules
Every class module from the official Entisoft Tools 2.0 Object Library, parsed, cross-linked, and instantly searchable.
Three Decades of Building Tools
Entisoft Units & Extra
Pioneered natural-language unit parsing for Windows & Office alongside hypertext geographic reference data.
Entisoft Tools 2.0 + SourceLink
Shipped 1,500+ enterprise VB/VBA routines, data structures, and tree-shaking SourceLink static analysis decades ahead of its time.
Pocket Tablet™
Award-winning Pocket PC pen tablet software earning Tucows Five Cows and Pocket PC Magazine Best Software nominations.
Modern Web & .NET 10
Entisoft's ideas live on across ConvertIt.com, PlacesNamed.com, ApexMicro.com, and this interactive Entisoft developer archive.