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 »
23 March 2010 by Ross McLean
Purna Duggirala. Purna Duggirala. Purna Duggirala. You might better know him as Chandoo, but his name is Purna Duggirala. Chandoo is a very friendly fellow, and we had a great chat about charts and dashboards, how to design them what approaches to take etc etc… So if that sounds like your sort of thing, have a listen.
The PHD company christmas card circa 2009......
Purna runs a great Excel site Pointy Haired Dilbert, it really is super, but I reckon that anyone who reads this will know that much already. He has an MBA from IIM Indore and Computer Science degree from Andhra University, and he’s an Excel MVP, of course! only the best for the readers (and listeners) of Methods In Excel.
One thing I didn’t know about Purna is his ability to multi task, the bat eared amongst you will be able to detect Chandoo simultaneously talking and typing away… no doubt writing some more excellent blog posts for PHD!
Podcast: Play in new window
| Download
Tags: dashboards, Downloads, Podcasts
Categories: Podcasts, Spreadsheet Design, UI Design •
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 »
15 December 2009 by Ross McLean
A bit more from the past, in this example file you can play a video natively within a VBA form – cool!
The example file here: Video API
Tags: API's, Dev Tools, Downloads, Videos
Categories: Downloads, Videos •
No Comments »
31 July 2009 by Ross McLean
Advances in Excel lightboxes! I’m not sure about you but my spreadsheet is just not complete unless I have some sort of lightbox viewer going on.
Juice have an example here, I have approached it in a slightly different way, and linked to a chart via a picture control, the example work book can be downloaded below.
And if you liked Advances in Excel lightboxes stay turned for Advances in Vista like buttons from shapes….what a world we live in.
Here’s the file: M.I.E Light Box
Tags: Charts, Downloads
Categories: General, Spreadsheet Design, White Noise •
9 Comments »
