What can you learn here ?
- Get started
- Short code snippets
- Abbreviated explanations
Quick examples get it now
This articles on this site are largely about how to do quite big projects. Realizing that you may have ended up here because you want a small snippet that shows how to do something, this section is dedicated to small snippets to get you started on a particular topic, with just a short explanation given. But if you are really just beginning, read Getting started with VBA first.Getting started series
Here are series of snippets showing how to 'get started' with a series of fundamental VBA topics
- Asynchronicity and Scheduling
- Getting Started with Classes
- Getting started with recursion
- Getting Started with argument passing
- Understanding Scope
- Objects and the garbage collector
- Sorting Collections
- Formatting range addresses
- Clean up Pivot Cache
- Use Microsoft Speech
- Looping through files in a directory
Quick Start
Tasters of various topics on this site.
How to do stuff
A series of short 'how tos' for things that are hard to track down Forms and Mice
- How to position a userform on the mouse
- Implementation example of form at mouse position
- How to traverse a treeview
Playing around with shapes
Colors, Charts and formatting
- Create a heatmap in Excel
- How to create a tag cloud
- A tagCloud in Outlook
- VBA rgb to htmlRGB
- Color ramp library
- Charts and color ramps
- How to create a heatmap doughnut chart
More esoteric stuff
Using Libraries and projects on this site
- How to use cDataSet
- Clear data cells with cDataSet
- Create a list of unique values
- Make a copy of a worksheet
- Make a filtered copy of a worksheet
- Make a copy of some of the columns in a worksheet
- Make a copy of a sheet and respect autofilter
- How to identify and modify rows hidden by autofilter
- Coloring maps and other shapes
- How to make a table from a cdataset
- How to use cJobject
- Passing complex arguments in VBA - copy how its done in javaScript
- use cJobject to create a unique list
- Web Services
- How to use the Excel Roadmapper
- Execute SQL from Excel
- Consolidating Sheets in an Excel Workbook
- How to do Basic HTTP Authentication from VBA
- What modules do you need
- Creating an index sheet for a workbook
- How to update modules automatically in VBA
JavaScript and Google Stuff
- javaScript 'howTo'
- From VBA to Google Apps Script
- How to simulate for each loop in javaScript
- How to use javaScript from VBA
- How to pass arguments to VBA using jSON - just like javaScript
- GAS hacks for VBA
- How to manage and share libraries in Google Apps Script
- d3.js
- Using scriptDB
- Tracking activity with ScriptDB
- Using Google Apps Script Content Service as wrapper for multiple APIS
- Displaying code samples on Google Sites
- Gas Publisher
- Badges
Excel formula tweaking
- Leveraging sorted data with Match
- Regular Expressions
- Named Ranges
- Named Ranges with Column Headings
- SumProduct
- Search
- 3d Validation
- Using match to categorize
- Respect a Filter with Sumproduct
- The birthday problem
- What to do if you get the "Object Library Invalid Error Message"
- How to embed gist code samples in Blogger
- How to embed gist samples in Google Sites
For more stuff see my book - Going Gas. All formats are available now from O'Reilly,Amazon and all good bookshops. You can also read a preview on O'Reilly.