VBA

The MIE Podcasts – Govert van Drimmelen

In this podcast we caught up with Excel DNA author Govert van Drimmelen. Govert is a Mathematics lecturer at the University of Johannesburg, in South Africa. Excel DNA has had some attention from the Excel blog sphere in the past few months, Simon, Mike, and Mathias have all posted about it. I’ve been using it for a while now, and it’s brilliant. Here we talked about how Excel DNA came about, the basics of how it works, some of the new features and what’s planned for the further.

Govert van Drimmelen, famous for his Tom Selleck impression

If you don’t know what Excel DNA is, well then listen to the podcast, but in short it’s a free and easy way to get .Net code into Excel.

I’m sure you will all join with me in thanking Govert, not only for making time for the podcast, but also for all the hard work he’s done  in getting Excel DNA out of the door – well done Govert!!!

And remember if you’d like to see more of Excel DNA, I’m giving a talk about it at the UK Excel Dev Con, in a weeks time!!!

Numric Libraries in VBA

Someone posted about 2 numeric libraries they had found for VBA, I think it was JKP, but I cant for the life of me find the post back in my reader, so sorry for not giving proper credit who ever it was – feel free to leave a comment and link and I’ll update this post, anyway the file can be found here – look useful!

http://www.axelvogt.de/axalom/index.html

http://www.alglib.net/

UPDATE!!!!!

Thanks to Dick K, it was Doug Jenkins (who else could it have been!) with the orginal post, thanks Doug….anyone notice how close Doug Jenkins is to Douglas Jardine…., no just me then, need to get out more I think!

Unit testing Excel VBA – xlUnit demo

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.

You can find out more about xlUnit at Mikes blog, grumpy old programer:

Pop up Style Forms in Excel

Final one in the blast from the past series, a pop up type form, you probably wouldn’t implement it like I’ve done in the example file but you get the idea!

popupform

The file can be found here: PopUpForm

Drawing on a VBA Userform

I’m making a few post with old stuff from my main site (which is now closed), this is so I can point to the blogpost when I update my downlaods page, which I am planing on doing at some stage in the next few years!

This example uses an API to let you actually draw on the form free hand style!

drawonform

It  can be downloaded here: Drawing_v3