IsValidUTF8 + DecodeUTF8 + EncodeUTF8

Checks UTF8, or convert to/from UTF8. Simple functions to convert the first 256 ...

TreeView

A plain pure VBA Treeview control to be used inside Excel (official link has ...

treeviewexcel025.zip

Records Affected by Execute command

Records affected by sql Execute command https://docs.microsoft. ...

SheetName

Gets a sheet name by referencing sheet ID or Sheet No This is more likely to ...

ChartMaxY + ChartMinY

Calculates the maximum of the chart Y Axis to draw, the shifted one, not exact ...

Base64encode + Base64decode

Encodes and decodes a string, Base64 is used to convert binary data (like ...

Encrypt1 + Decrypt1

Encrypts (and decrypts) a string. To decrypt an encrypted string, use the ...

IsPrime

Checks to see if a number is a primary number. Prime numbers are commonly found ...

UnBreakAr + BreakAr

Fix broken Arabic char, by using AscW and ChrW This is Excel User-defined ...

doHighlight

Search for occurrences of a keyword in a string and highlight them, by either ...

ProtectText + UnProtectText

Encrypt or decrypt text, simple encryption with a numeric password Decrypt a ...

myURLDecode

Decode a URL, opposite of Server.URLEncode