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
Tag: Downloads
Playing Video Files in VBA forms
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
Excel Lightbox Viewer
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
Excel VSTO Addin example video!
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!
Anyway, here it is!
MIE Sample VSTO Timer Addin.zip project to go with it, should anyone be interested
I’m glad that’s done!!!
Note to self, don’t do end to end videos!
Custom Form Shapes In VBA and Excel.
You can customise the shape of your user forms, and it’s Kewl! All the kids in my house are doing it! Look at this stupid form shape I was able to make!
Why on earth would you want to do it I hear you ask?! That’s a very good question! When I started this I thought it was really not very useful at all. I’m still thinking that, but maybe there might be a few practical uses for it. I’m thinking tool tips and popup type things. I have covered using captionless user forms (and worksheets!), and even popup forms previously. I was never happy with the way the captionless forms looked in VBA, they look ok in VB6 but in VBA they has a wafty boarder.
Of course if you want to move over to VSTO you can even make a user form in the shape of John Walkenbach’s upper half! Is that the sound of ringing tills I can hear!
Release.zip (Excel 2007 only + .Net 3/3.5)