-
Visual Basic – Multiple Undos Class v2.04
I tried a lot of differnet multi undo solutions, but every had at least one draw back. So I had to write my on solution and I think my one is quite smart.
If you want to use it, you don’t have to clutter your code by pasting in lots of undo-related subs, functions and variables. Everything comes within two small class files.
-
Visual Basic – High Precision Timer v1.20
This code is a VB implementation of the high precision multimedia timer which can be found in the winmm.dll.
I wrote this code because of the same reason I developed the multiple undo class: I wanted to have a smart solution that can be easily added to different VB projects, that doesn’t clutter the code, that doesn’t let depend my project on another custom OCX or DLL file and that is object oriented as much as possible.
Read the rest of this entry » -
Excel – VBA Timer Example v1.00
A friend of mine asked me about how to let excel periodically update some worksheets.
So the first thing I did was searching the web for a solution in Visual Basic for Applications. But the only one I found was to use a 3rd party ActiveX timer control which you have to place onto a userform. Then I found the VBA command “Application.onTime” and had an idea.Here is my solution only utilizing the VBA onTime command. No need for ActiveX control or any other 3rd party module.


Looking for a high performer for your next IT project?

English
Deutsch
Recent Comments