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

Card image cap
Zip_Folder

Zipping content of folder into file. Not tested and Not My Work. Originally ...

Card image cap
AskForFolder

Asks user to assign a folder, been looking for something like this for awhile ...

Card image cap
ImportCSVs - 1st AI Code

Imports multiple CSVs found in a folder into worksheets of active workbook ...

Card image cap
Convert_Dash_to_Zero

Convert cells with dashes to zeros. Quick code needed to reset sheet copied ...

Card image cap
Range2Block

Concatenate all rows found in a range starting A1Cell for Columns_To columns ...

Card image cap
Range_Add_or_Subtract

Adds an amount (or subtract) from a range of cells in one click Similar to

Card image cap
NavigatePost

Reads content of webpage with optional post data two main differences from

Card image cap
ANmaVLookup

Finds first occurrence of item in column, then returns value from same row as ...

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