Codes Required
SettingSave + SettingRead for NumberFormat
Reads or applies certain NumberFormat to cell in settings. Same patterns as ...
Apr19
CopyFields_FromTo
Moves strings within cells into other cells, move or copy. Specific task to ...
Apr17
Protect txt file into word doc with password
Saves txt file as word doc with password. Passing txtfile having full path and ...
Jan4
Macro keyboard shortcuts
Assign certain keyboard shortcut to certain macro, or clear that shortcut. ...
Dec13
DB Functions (By AI)
3 functions to add or update data to DB and Read from DB. These were also ...
2023Apr23
WordPress - Excel functions (AI)
3 functions to download posts, adds new post and to upload and set featured ...
2023Apr22
ScrapeURL_ToSheet
Reads content of Page from URL to a sheet. This was made specially for certain ...
2023Apr4
Convert_Dash_to_Zero
Convert cells with dashes to zeros. Quick code needed to reset sheet copied ...
2023Mar14
LstCustomSelection_Refresh
Read list of items from Settings sheet, then Sort, then save, before reading ...
2022Aug31
AutoSaveOn
Automatically save workbook (when using OneDrive) on or off This is the VBA ...
2022Feb23
UISetup + UIRestore
Simple way to freeze UI in Excel-VBA then restore it after complete in standard ...
2022Jan28
DirectionToggle
JS to switch direction between Right-to-Left and Left-to-Right Toggle the ...
2019Sep18
ANBS controls
Set of functions to generate Bootstrap controls as strings. Controls available ...
2018Jun24
InsertHyperlinks + GetHref
Converts https found in text into anchers < a > Comes with GetHref as bonus ...
2018May13
Similar codes
Pps vs ppsx
PowerPoint slideshow file types and differences in file size. Bottom line, if ...
2020Dec20
SimpleSlideView
Good slide view, animated moving menu, or wizard steps
From
2019Jul4
AutoSaveOn
Automatically save workbook (when using OneDrive) on or off This is the VBA ...
2022Feb23
CopyFormat
Applies format into a cell (or range) from another cell. Can apply from any ...
2018Aug10
Excel sheet textbox
Found a strange behavior for Excel sheet textboxes. Textbox in Excel sheet, ...
2020Feb22
Easy Ticker (jQuery)
Simple great ticker (vertical slideshow) with some options.
From
2019Jul4
CreateThumb_IrfanView
Creates a thumb of an image using IrfanView Thumbnail filename will have _th ...
2018Jul22
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
