AJP Excel Information

VBA Code

VBA coding techniques, solutions and examples

Chart Labeler for PowerPoint

VBA Add-in to link chart data labels to cells.

Chart Text Mover

VBA Add-in to move chart text items. There is versions of the add-in for PowerPoint and Excel

Userform Textbox Contextual Menus

A class object to add a Contextual Menu to textboxes

RibbonX Visual Designer

VBA add-in with which to create ribbonx code.

NB. Not tested in 2010 beta or 64bit Windows/Office

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 16th October 2010