SetTimer Windows timer from cpearson

[iknowu99]

i'm trying to declare first two variables but it's showing up as error and font is in red:

Public Declare Function SetTimer Lib "user32" ( _
    ByVal HWnd As Long, _
    ByVal nIDEvent As Long, _
    ByVal uElapse As Long, _
    ByVal lpTimerFunc As Long) As Long

Public Declare Function KillTimer Lib "user32" ( _
    ByVal HWnd As Long, _
    ByVal nIDEvent As Long) As Long

and yea thanks to: http://www.cpearson.com/excel/OnTime.aspx
because first one works...just trying to explore using windows timer

 

[shg]

Declare what two variables? The function declarations are fine -- they have to appear at the top of a code modules, right after any Option statements.

 

[iknowu99]

thanks for the shout back,
i added 'ptrsafe' word before 'function' and it works

something to do with 32 bit to 64, i'm using 64 right now..