Timer Problem 1

[paul51]

I am using a VBA shell to do some programming, and I cannot locate the 'timer clock' control. I left clocked on the control dialog and added every control that was available, but the timer clock was not there.

When I open a normal VB window, it is present as one of the listed controls, but not a VBA program.

Does anyone know how I can add this. I am guessing that there is some reference that I am missing, but I cannot fing it.

 

[tsdragon]

Try the VBA forum.

Tracy Dryden

Meddle not in the affairs of dragons,
For you are crunchy, and good with mustard.

 

[strongm]

VB has a Timer control

VBA does not - although you can achive some of the same effect using the OnTime method. You coukld always write your own Timer class ... (basically, you'll want to look at the SetTimer API)

Or there's the CCRP's Timer DLL

http://ccrp.mvps.org/index.html?controls/ccrptimer6.htm