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
VBA
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
64 bit VBA
In my last post, VBA Version 7 Daniel, author of Daniel’s XL Toolbox, commented that he had not come across anything untoward with the “new!” version of VBA, and reported, so far, all is well with his addin – good news! Then JP from Code For Excel & Outlook, pointed to a VBA Compatibility tool (tool, info) from MS – thanks JP, I think this is called team work! ;-)
Anyway, I believe the major update might be support of 64 bit types in VBA? I’m not running a 64 bit OS to test, but I found this:
Excel 2010 can load much larger workbooks. Excel 2010 made updates to use 64-bit memory addressing in order to move beyond the 2-GB addressable memory boundary that limits 32-bit applications.
The down side of this is:
Visual Basic for Applications (VBA) VBA code that uses the Declare statement to access the Windows application programming interface (API) or other DLL entry points will see differences between 32-bit and 64-bit versions. The Declare statement must be updated with the PtrSafe attribute after inputs and outputs to the API have been reviewed and updated. Declare statements will not work in 64-bit VBA without the PtrSafe attribute. New data types are added to 64-bit Office 2010 VBA: LongLong and LongPtr. For more information about VBA, see the “64-bit VBA Overview” and “Declare Statement” articles in the Microsoft Visual Basic for Applications online Help in Office applications.
So if your using API calls in you VBA, and you hit a 64 bit versions, you could be about to hit some issue. Doesn’t sound like the fix will be to hard though, but we’ll wait and see eh!
Bonus thought: Does this mean the C API has been updated too?
VBA version 7?
Any one else noticed this?
Thats a Major revision number, that should mean there’s been some significant updates should it not? Anyone seen any, I’ve haven’t!