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

Card image cap
Part of cells in Excel

How to modify part of text inside an Excel cell using VBA. Something in my ...

Card image cap
ListBox_Excel_Sort

Sort items in Fm20 Listbox using Excel spreadsheet Sort function. Can decide ...

Card image cap
UI_2ValidationsUpdate

Apply validation on two cells, when a 3rd cell is changed When modifying a ...

Card image cap
CreateList_Matching

Creates list of items found in rows, where these rows match a value in another ...

Card image cap
Column2AnString_Unique

Creates list of unique items found in a column, returns string with items ...

Card image cap
FolderSize_Swift

Gets total of folder size in bytes. With some tweaks, you can modify it to use ...

Card image cap
Delete_Unwanted_Rows

Delete rows in a different way I used to delete rows by looping through those ...

Card image cap
DeleteOtherSheets

Deletes all sheets in a workbook keeping only one

Card image cap
IsThere1_SPWB

Checks if a workbook is found in a SharePoint location or not, giving a full ...

Card image cap
NextID_Reset

Checks if ID has been reset in SQL database table If yes, it will reset it and ...

Card image cap
DB_Connect_Install

Connects to SQL DB using ADODB, if driver not installed, it will attempt to ...

Card image cap
Custom Excel Right-Click Menus

Customizing Excel's right click menus The following code demonstrates how to ...