5 July 2010 by Ross McLean
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!!!
Podcast: Play in new window
| Download
Tags: Addins, Excel DNA, VB.Net
Categories: C/C++, Podcasts, UDF, VB.Net, VBA, VSTA, VSTO •
No Comments »
1 April 2010 by Ross McLean
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!
Tags: Downloads, Libraries, VBA
Categories: VBA •
3 Comments »
16 December 2009 by Ross McLean
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!

The file can be found here: PopUpForm
Tags: Downloads, Forms, VBA
Categories: VBA •
1 Comment »
14 December 2009 by Ross McLean
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!

It can be downloaded here: Drawing_v3
Tags: API's, Dow, Examples, Forms
Categories: UI Design, VBA •
6 Comments »