DirTree.xlsb

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

DirTree.zip

Pure CSS line graph

Simple, with CSS only, an HTML line graph By

csslinegraph.zip

DialChart - Excel-VBA

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

DialChart.zip

Web browser in Excel VBA

Example on how to use Web browser control inside Excel userform

WebBrowser.zip

SheetAdd_ANmar

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

Porting Excel/VBA into OpenOffice Calc

PDF document on what needed to import VBA from Excel into OpenOffice Calc Basic

MinIF and MaxIF in Excel 2010

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

MaxIF_MinIF_byNMR.zip

User-Defined Formatting

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

Open different Filestypes

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

Val2

Converts anything into an integer I used the function VAL() a lot, it is in ...

Show/hide ribbon

Show or hide Excel ribbon from inside VBA Needed that in one of my projects

ChrW

Insert special characters inside Cell, using ChrW