|
VBA Code
VBA
coding techniques, solutions and examples
VBA add-in with which to create ribbonx code for
both 2007 and 2010.
Requires Excel 2010 to access customUI14
section.
VBA Add-in to link chart data labels to cells.
VBA Add-in to move chart text items. There is
versions of the add-in for PowerPoint and Excel
A class object to add a Contextual Menu to
textboxes
VBA add-in with which to create ribbonx code.
NB. Not tested in 2010 beta or 64bit Windows/Office
VBA code to add and align textboxes in place of
Axis labels
A class object to handle moving list items either
up and down or between two listboxes.
The hands are adjusted by moving the mouse over the dial
A class to dynamically resize controls and
userform using user definable anchors
A class to dynamically add splitter controls to
userform
Add resizing handle to userform without the use
of APIs
Drawing shapes on a user form
A collection of various progress bars.
An add-in for creating button images.
Class to turn a list box into a treeview.
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
Class to emulate What's This help on a userform.
Class to emulate colour enabled dropdown list
control.
Last updated 8th April 2012
|
AJP
Excel Information
(Excel 2000
and above)