VBA-Excel 329
Visual basic for applications that works only in Microsoft Excel, aka macros
Listbox 1st item [Any]
Allow user to select [Any] as first item in list that will deselect all other ...
ANStr2Range
Converts a string of items into range, with custom separator. Opposite of
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 ...
