| Name | Description |
| For Developers | |
| Pop up form | Some API’s that make a userform work like a popup style form. |
| Video on a userform | The file uses a few API’s to play, natively (i.e. no Active X dlls), video files on a VBA userform |
| VSTO Addin example | An example of how to write a VSTO addin, a Youtube video, and a sample project |
| Custom Shapes Userforms | In this example we make a complexly custom shaped user form, using some API’s, also shows how to make rounded corners on a form. |
| Do Events | Example of how to use Do Event in VBA – a simple cancel implementation. |
| Fuzzy Logic | A set of UDF’s that implement fuzzy logic algorithm in VBA:
Levenshtein distance Jaro-Winkler Longest Common Subsequence Dice Coeffient |
| Geocoding UDF | Example of how to use Google Map’s API to implement geocoding within Excel. |
| Excel Instance from VB.Net | Example of who to use some methods of the .Net frame work hook into an Excel instance and code against it objects |
| Excel Front Loader | A .Net implementation of a Excel front loader. |
| “Power Users” | |
| Data encryption | An implementation of a simple data encryption algorithm to encode data in a workbook. The VBA code travels with the workbook, and the data will be decrypted at the “other end” if the correct keyword is supplied. |
| Immediate window hook | Ever wanted to use the immediate window from the Excel client window? Not actually a file to download, but the codes in the post. |
| Colour Pallet – Gradients | A tool that lets you create a gradient set of colours and save them to the workbooks colour pallet. XL 2000 to 2003 only! |
| Captionless worksheet | Ever wanted to remove the boards and title bars from a worksheet – not really eh. Well if you ever did, here how!? |
| Inline worksheet help | A few ideas of different ways to show help on the worksheet. |
| Spell Checking Tool | Spell checking is fine in Excel, but typing lots of text into a cell can be a pain. This example uses a userform and does some clever stuff to add spell checking to that form, before posting the result back to the cell – cool. |
| Light Box | Another implication of a “light box” type functions for Excel. This uses shaped and the picture function to produce a live update of some area of a sheet.
NOTE: – Does not work with Excel 2007 + |
| Addins | |
| Colour Manager | An addin that lets user pick colours from a picture an use them in Excel. Also creates a text file to store the new pallet, which can be saved and managed through the addin |
| Calulation Timer | An addin that will time calculation speeds of workbooks, worksheets and ranges. Options to do multiple calculations and work with iterations. |
ped wanted
Hi,
I’ve just started with vba programming. By googling I found your blog very interesting and maybe you ould help me
I’m trying to implement a kalman filter algorithm within vba excel.
Would you like to help on it?
The model I want to use is :
X(t+1) = A + B*X(t) + u(t) u ~ N(0,Q); N where stands for Normal Distribution.
Y(t) = C + D*S(t) + e(t) e ~ N(0,v)
X(t) is the state (non variable and Y(t) the measurement
X(t) is p x 1 matrix
A is p x 1 matrix
B is p x p matrix
u(t) p-multi-Normal Distribution, ie a realisation of u(t) is p x 1 matrix. Therefore Q is p x p covariance matrix.
Y(t) is n x 1 matrix, n is the number of observations.
C is n x 1 matrix,
D is n x p matrix,
e(t) is n x 1 matrix, a Normal Distribution, a realisation of e(t) is a real number
Here are some link where the algorithm can be red
http://www.cs.ubc.ca/~murphyk/Software/Kalman/kalman.html
http://www.jstatsoft.org/v39/i02/paper
thank
Zoul
Hi Ross,
Great website, resources and insights!
We recently launched Vumero.com – a marketplace for Excel Spreadsheets and Financial Modeling expertise.
I thought you might like to check it out and share your thoughts/suggestions. My email is above.
Thanks so much and keep up the top work in 2012!
Yours appreciatively,
John Persico
Chief Executive Officer
Vumero.com