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
Tag: API’s
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!
It can be downloaded here: Drawing_v3
Captionless worksheets
Big Dick Kusleika over at Daily Does of Excel made some suggestions for Excel 12. One of which was to have captionless worksheets.
The following example sort of does it, it’s a modification of Steven Bullen’s and Tim Clem’s Form fun class.
I didn’t spend very long on this as it’s not really of any use to me, I just wondered if it could be done. To use it in anger you’d have to tightly control the windows index and there protection settings I’d guess. And what about adding transparency?
Speed Basic Update!
So i installed and played around with SpeedBasic. I chose to install the Borland C++ compiler, even though i have MSVC. I can honestly say it was a breeze. Much easier that installing VS6 or VB express! (This is stupid, how can it be that one man working by himself can do it better that MS????!!!!, lol!)
Anyway, I don’t really know much about none MS BASIC syntax, but it was easy enough to build a hello world app. Install to compilation took about 20 mins – not bad!!!!
I have found out that SpeedBasic is not being developed anymore. To be honest, the program show load of potential, but I think you’d struggle to develop any data centric app with it. It will stay on my PC for now, but I think until I become quite proficient with C++ and BASIC, it’s use will be limited if you are cognisant of these languages it still might be worth a look esp. for compiling .dlls. Whatever.
Anyway while I was looking a SB, I came across B++ [1 2]. That’s next on the list!!!
