Back in February I did a podcast with Mike Woodhouse, based around testing VBA code. Mike has written a unit testing frame work for VBA code, called xlUnit. Over the last few weeks I’ve been using xlUnit to help write a generic validation class for VBA, so I thought I would put together a little video of how the addin can be used to write tests for your code.
Its in 2 parts because you can only upload videos that are 10 minutes long to you tube. The first part is the basics and in the second part I show some examples from my project.
A day and a half behind schedule, here’s a long (10mins!) video of how to write and “deploy” as VSTO addin for Excel 2007. It was, to be honest, a nightmare to do, as my PC is about 100 years old! I promise that as soon as the funds allow I will get a new one – at least now I have a legitimate reason for the spend!
The sound and the image get out of sync about half way through, for which I apologise, but I’ve already spent enough time on it, and people should be able to keep up, there’s nothing to difficult about it. Editing in Widows Movie Maker is rubbish!
Here is the BETA version of my Colour Manager, and tool for creating colour pallets in Excel:
It’s a VB6 com addin, the only thing you really need to know is that you load a picture on the left and then click that picture to get the colour at that point. You can then click a pallet square to place it where that square is. Click the send to workbook button to send it to the active workbook.
However I have also made a video to show how to use it. Bosh!
Here at MIE, we strive to bring you cutting edge news and information : spreadsheet wars
Worth a watch if you have a 1/2 hour with nothing better to do!
