![]() Public Declare Function KillTimer Lib "user32" ( _īyVal HWnd As Long, ByVal nIDEvent As Long) As Long Public Declare Function SetTimer Lib "user32" ( _īyVal HWnd As Long, ByVal nIDEvent As Long, _īyVal uElapse As Long, ByVal lpTimerFunc As Long) As Long Private Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long) Here is the full module: Rem Attribute VBA_ModuleType=VBAModule Is there some equivalent to this in LibreOffice's implementation of VBA? Google searching tends to just produce Microsoft's docs which are not helpful. ![]() The part of code highlighted by the IDE when it errors is this: SetTimer(0&, 0&, t * 1000&, AddressOf I think it's the AddressOf part which it has trouble with, it doesn't seem to be rendered like a keyword. TimerID = SetTimer(0&, 0&, t * 1000&, AddressOf TimerProc) Here is the function in question: Sub StartTimer() When I try to run the code, LibreOffice Calc complains that the " parentheses do not match". I have a function in some Excel VBA which sets up a timer.
0 Comments
Leave a Reply. |