SettingSave + SettingRead for NumberFormat

Reads or applies certain NumberFormat to cell in settings. Same patterns as ...

ListBox bug with TabIndex

Setting TabIndex for a listbox to 0 in a Userform will have some issues when ...

DateDateDate

Finds three dates after each other in one paragraph. Needed to locate numbers ...

VBInstrRev

Similar to VBInstr, but this one does it in reverse, which is instrrev() ...

GeWin - get windows list

Gets all windows that are enabled and actived and put them in a list. It also ...

GEWin.zip

HTML2Str

Sppecial version to convert HTML to string. Uses RemoveHTML, then after that ...

Modal form open Workbook

Do not open workbook from userform after .show

Refresh Table from View

Convert SQL View into table for speed reading. Using views a lot, I needed a ...

MapPath_SafeComma

MapPath version expecting comma in filename or folder. Just because we might ...

ForegroundColor

Returns white (RGB 255,255,255) or Black (RGB 0,0,0) based on background color ...

ANmaInt

Cuts the integer part of a number. Like INT, FIX, or CINT I know we already ...

GetAmazonPrice

Reading price of an item in Amazon. An AI-generated function with AI-generated ...