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

Card image cap

Excel macro to show all files found in directory (including sub-directories) as ...


Card image cap
DialChart - Excel-VBA

A dial chart inside Excel using VBA code. With options to show 3 areas and two ...


Card image cap
Unprotect sheet or workbook

Unprotect worksheet (and workbook) using VBA code


Card image cap
Web browser in Excel VBA

Example on how to use Web browser control inside Excel userform


Card image cap

Unmerges all merged cells and duplicate cell contents into them. In another ...

Card image cap
Select workbook (or workbook/worksheet) (Frm5)

Gives your user ability to select a workbook from list of open workbooks within ...


Card image cap

Adds a sheet to a workbook, after checking if workbook is open Checks if ...

Card image cap
User-defined type error

How to fix error (User-defined Type) error, especially when using outside ...

Card image cap
MinIF and MaxIF in Excel 2010

MinIF to calculate smallest number matching certain criteria, in Excel 2010 ...


Card image cap
User-Defined Formatting

Apply special Conditional Formatting, color cells based on their values. This ...

Card image cap
Open different Filestypes

Populate list of filetypes in Application.GetOpenFilename method. This command ...

Card image cap
Run macro

Runs a macro from another workbook (Workbook has to be open).