What Is a Class?
Classes are Objects which allow you to group a set of related functionality into one group. Once you have defined your class, you instantiate an instance of a class in order to use it. Using classes leads to clean, understandable code. If you are a 'class newbie', you may want to first read Getting Started with Classes. Below are some of the classes implemented in the downloadable examples of this site.List of a few of the custom classes referenced by this site
- Introduction to Classes
- Data Manipulation Classes required to make use of Data Manipulation procedures: For Intermediate skills updwards VBA developers who want to practice familiarity with classes, and use some ready to use spreadsheet tools to avoid repetitive coding. Get it now
- cJobject enable the serialization and deserialization of Excel-JSON data
- cShapeContainer a class representing a shape on a roadmap
- cGoogleChartInput generate google visualization data and scripts from Excel data
- cBrowser access and initiate browsing
- cCookie store Excel data in a cookie
- cGeneralObject standardize the properties of Excel shapes and controls
- cProgressTimer a countdown or progress timer that can use any excel shape
- Sudoku classes various classes used in the generation and solving of Sudoku puzzles
- cChartContainer enable charting associated with roadmaps
- cShapeTraceability embed JSON data genealogy data in roadmap shapes
- cOutlookApp Kick off Outlook session
- cOutlookAddressBook Populate Excel sheet with selected data from Outlook Address books
- cRest A library and classes to populate excel sheets from common restful queries
- cADO A library to execute SQL from Excel
- cTagCloud A class to automate making a tag Cloud in Excel
- cStringChunker Optimize string concatenation performance
- Promises in VBA An experimental implementation of deferred classes to enable asynchronicity in Excel
- OAUTH2 and VBA A class to allow oauth2 authentication for VBA
- Instrumenting VBA for Google Analytics send signals to google analytics to track usage, timings and other events
- parse.com api class for VBA A wrapper API for the parse.com restAPI - a noSQL database for Excel
- A VBA API for scriptDB cScriptDB class