VBA-Excel 326
Visual basic for applications that works only in Microsoft Excel, aka macros
Dropdown button commands
A drop-down of multiple commands in pure VBA. Needed this in a large Excel-VBA ...
Cell_Add_or_Subtract
Adds amount to active cell, or subtract Applies to selected cell in current ...
LstCustomSelection_Refresh
Read list of items from Settings sheet, then Sort, then save, before reading ...
ANmaBatchCreate + ANmaBatchRun
Creates batch file with certain content, and another function to actually ...
HyperlinkFunction
Returns the formula for a hyperlink [=Hyperlink(...) ] to be inserted in a cell. ...
AddDatabar_ConditionalFormatting
Adds databars conditional formatting to range of cells. Passing column, start ...
SettingNameAlreadyFound
Searches for a setting value in set of Settings, in Excel spreadsheet using ...
Shape_Select_or_CreateThenSelect
Selects a shape inside sheet to change it, or if not found, it will create it ...
ANmaSQL_UpdateDateStatement
Creates "Update Table " SQL statements to be executed inside SQL to modify ...
ANmaSQL_InsertStatement
Creates SQL INSERT statements from a table in Excel. Used to be executed to ...