VBA PROGRAMMING
Set Timed Events in Microsoft Visual Basic .NET with Win32 API Callbacks
Being able to use callbacks allows you to use an entire class of Windows API functions that are otherwise unusable from VBA.
Subscribers: Sign-in to activate download link -- Get the sample application described in this article.
About this Article:
Many Windows API function calls require you to pass a callback function, a task which used to be impossible in VBA -- but not anymore. Find out how to exploit the Windows timer function with the AddressOf operator.
Technical Editor Ken Getz is a programmer, technical writer, educator,
and senior consultant with MCW Technologies. He's a lead courseware
author and presenter, he develops custom Windows and Web applications and tools using Visual Studio and Microsoft Office, and he's been a Microsoft MVP award winner since the program began. Ken is a frequent speaker at Microsoft events, ADVISOR SUMMIT, and other technical conferences. He's co-author of ASP.NET Developer's Jumpstart, Access Developer's Handbook series, and VBA Developer's Handbook. http://www.mcwtech.com/cs/blogs/keng