VBA-Excel 200 Visual basic for applications that works only in Microsoft Excel, aka macros

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
Popup button

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

Drodown-popup-Button.zip

Card image cap
Dropdown button commands

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

DropdownButton.zip

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 ...