| Downloads |
Tools
Coming soon!
Workbook Addins Manager
coming soon!
Example work Books
Popup Form - makes a userfrom behave like a popup form, the form disappears when the mouse is moved off the form's surface.
Off sheet referencing - shows some methods of getting cell values from different sheets and workbooks. Also demonstrates how to get values from the pervious and next sheet and provides an offset sheet function. Accompanying article: No, the one before the one before.
Drawing on a Userform - A simple example of how to draw directly on to a user form. Uses API calls to paint directly on to any device context (in this example the form).
Playing video on a Userform - via the MCI API. The easy way to play video is using the Media Player active -x control, but that offers no real control over the video. This example uses a VCR class with which you can do quite a bit (adapted from Steve Browns in VB developers Guide to the Win32 API). Not all the MCI methods are in the class, but they can be found here:
In-Line Help examples - four methods you may like to use for displaying "inline" type help. These are suitable for small scale help topics, access directly at the place where help is needed.
Captionless worksheets - A excel worksheet which displays without captions or boarders. This is simply achieved using Steven Bullen's and Tim Clem's form fun class.
Moveable captionless user form - A methods to enable move of a captionless VBA user form
VB.NET Excel Front Loader (project, exe) for explanation and usage see here
Google Adds ?