Recent codes added Codes added recently by our developers. 18 most recent codes.

Card image cap
MultiTrim

Trims leading and trailing tabs, spaces and Enters Code has lines to work in ...

Card image cap
Antispam - Hiding textbox

Anti spam email web form idea.

Card image cap
Listbox 1st item [Any]

Allow user to select [Any] as first item in list that will deselect all other ...

Card image cap
ANStr2Range

Converts a string of items into range, with custom separator. Opposite of

Card image cap
SwapNumbers

Swap two numbers variables without using third variable A trick worth saving ...

Card image cap
Popup button

List of commands in popup menu. Uses listbox, command button and toggle ...

Card image cap
Dropdown button commands

A drop-down of multiple commands in pure VBA. Needed this in a large Excel-VBA ...

Card image cap
RunOnTime

Runs a certain macro on certain time. This is not a scheduler, but just simple ...

Card image cap
ANmaRemoveDuplicates

Removes duplication in table in 1 or more columns. Will work in sheet, ...

Card image cap
ANmAdvancedFilter

Filter table inside Excel the fast way (using advanced filter) into another ...

Card image cap
Cell_Add_or_Subtract

Adds amount to active cell, or subtract Applies to selected cell in current ...

Card image cap
LstCustomSelection_Refresh

Read list of items from Settings sheet, then Sort, then save, before reading ...

Card image cap
ANmaBatchCreate + ANmaBatchRun

Creates batch file with certain content, and another function to actually ...

Card image cap
HyperlinkFunction

Returns the formula for a hyperlink [=Hyperlink(...) ] to be inserted in a cell. ...

Card image cap
AddDatabar_ConditionalFormatting

Adds databars conditional formatting to range of cells. Passing column, start ...

Card image cap
SettingNameAlreadyFound

Searches for a setting value in set of Settings, in Excel spreadsheet using ...

Card image cap
DiskDriveType

Returns drive type as text, like fixed, CD, etc. Can pass either drive letter, ...

Card image cap
LastRow_Remove

Removes last row in a table starting certain cell. Creating and using this ...