usage "AddressOf TimerProc" in Excel97

[tom taol]

how to use AddressOf in XL97?

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Robin Hammond]

Chip Pearson deals with Windows timers here:
http://www.cpearson.com/excel/ontime.htm

Or, I have an activex control for use in VBA here:
http://www.enhanceddatasystems.com/E...ExcelTimer.htm

Robin Hammond
www.enhanceddatasystems.com


"tom taol" <tom@yahoo.com> wrote in message
news:eIiF3He%23EHA.3700@tk2msftngp13.phx.gbl...
>
>
> how to use AddressOf in XL97?
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

[Jamie Collins]

Robin Hammond wrote:
> > how to use AddressOf in XL97?
> >

> Chip Pearson deals with Windows timers <snip>

Robin,
AddressOf was added to VBA6, comtemporary with Excel2000, however OP is
using Excel97 i.e. VBA5.

Jamie.

--

[Jamie Collins]

tom taol wrote:
> how to use AddressOf in XL97?

After a quick google:

http://www.trigeminal.com/lang/1033/...p?ItemID=19#19

Jamie.

--