VBA-Excel 326
Visual basic for applications that works only in Microsoft Excel, aka macros
Sorted from new to old.
UI_2ValidationsUpdate
Apply validation on two cells, when a 3rd cell is changed When modifying a ...
CreateList_Matching
Creates list of items found in rows, where these rows match a value in another ...
Column2AnString_Unique
Creates list of unique items found in a column, returns string with items ...
Delete_Unwanted_Rows
Delete rows in a different way I used to delete rows by looping through those ...
Custom Excel Right-Click Menus
Customizing Excel's right click menus The following code demonstrates how to ...
Remove_Between2Quotes
Remove any char (or string) found between two quotes in a string This is an ...