VBA Corner

VBA Corner presents some VBA solutions which help creating rich MS Excel applications. The solutions often utilze the Windows API.

The Solutions cover:

• Array sorting (Shell Sort)
• Finding in Array (Binary Search and Sequential Search)
• Multiline Tooltips
• Resizing of User Forms
• Adding Maximize and Minimize Buttons to VBA User Form and
• Date Picker Control (Month Control)

The demonstration projects and code examples can be used within your projects. Most of the code was found on the Internet and has been extended by us. Some of the codings were ported to MS Excel since being solutions for VB or MS Access.

Where appropriate the original source of the code is listed so you can check the original solution, too.

The solutions can be browsed online since all the coding is giving as HTML data; alternatively download the project files. The project files are fully functional MS Excel files.

System Requirements:

• MS Windows 2000 or higher
• MS Excel 2000 or higher

Enjoy