Codes Required
ListBox_Excel_Sort
Sort items in Fm20 Listbox using Excel spreadsheet Sort function. Can decide ...
2020Sep21
XLShortcut_EnableDisable
Disables or Enables certain Excel built-in shortcut. Code has example on how ...
2018Aug16
ExcelMenu_onfly
Creates Excel menu on the fly, list of menu items, command actions, and icons ...
2018Jul17
Similar codes
UnBreakAr + BreakAr
Fix broken Arabic char, by using AscW and ChrW This is Excel User-defined ...
2018Jul25
Excel 2010 hyperlink issue fix
An issue I started to see when clicking on a hyperlink in Excel 2010, while I ...
2019Jun16
User-defined type error
How to fix error (User-defined Type) error, especially when using outside ...
2019Feb1
RemoveDuplicates
Removes duplicated items from a 1-dim array into new array, does not modify ...
2022Jul7
Max + Min + Min_No0s
Calculate maximum of array of numbers or Minimum of array of numbers Also, ...
2019Dec31
Subtotal_Indirects
Finds the SUM, COUNT, COUNTA, etc for a range of cells referencing using ...
2021Nov26
Nautical/Flight Functions
Functions perform various calculations useful for planning trips. MPH2Kt: ...
2020Oct13
O365 Blocked Macros
Recent Microsoft 365 Excel blocked macros from running when they are in ...
Jul10
Recently by developer
CountColumnCells_2Criteria
Counts how many cells matching 2 criterias.
Just like
Wed 7AM
Files_FoundHours
Listing the file from a folder that was created during last few hours. Can ...
Tue 7AM
ANString_Location
Finds the location of a sting inside list of strings with certain separator, or ...
Apr23
Random Codes
NumberNumberNumber
Finds 3 numbers in a string by ignoring characters between them. ' example ...
Mar2
ShapeRange_BG
Replaces the background fill of any shape in Excel with an image Not Ready yet, ...
2021Mar27
LEGO cube loader
Pure CSS LEGO loader
This looks great for my 7Bricks project
From
2019Jun21
Win10 User Folders
I hate it when Microsoft takes back some controls it already gave to users, one ...
2018Jul9