AJP Excel Information

VBA Code

VBA coding techniques, solutions and examples

Axis labels using textboxes

VBA code to add and align textboxes in place of Axis labels

Listbox move items class code

A class object to handle moving list items either up and down or between two listboxes.

Userform Clock

The hands are adjusted by moving the mouse over the dial

Anchor controls and resizing userform

A class to dynamically resize controls and userform using user definable anchors

Userform splitter class

A class to dynamically add splitter controls to userform

Resize userform

Add resizing handle to userform without the use of APIs

Userform drawing (Excel 2000 and above)

Drawing shapes on a user form

Progress Meters

A collection of various progress bars.

Button Editor

An add-in for creating button images.

Hierarchical Listbox

Class to turn a list box into a treeview.

Graphics Exporter (Excel 2000 and above)

Add-in for exporting items in your workbook to graphics files.
The new features mean the latest version will only work in xl2000 or later

What's This Help

Class to emulate What's This help on a userform.

Coloured dropdown

Class to emulate colour enabled dropdown list control.

Last updated 3rd February 2008