Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
AddressOf
Hello,
Doe's "AddressOf" works with Excel macros? I keep getting a Compile Error for using it. "Invalid use of AddressOf operator" This is the code: Private Sub TestSub() i = 0 End Sub Private Function GetAddr(ByVal Addr As Long) As Long GetAddr = Addr End Function Private Sub Test() Dim Addr as Long Addr = GetAddr (AddressOf TestSub) End Sub The error is for Test Sub Tnx |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
AddressOf
I don't have much experience with AddressOf, but from what I can see, if
TestSub is moved to a regular module that should fix it. From my book "VB and VBA In a Nutshell" by Paul Lomax: AddressOf Operator Rules at a Glance: "The callback function must be stored in a code module; attempting to store it in a class or form module generates a compile-time error, "Invalid use of AddressOf operator." When I tested your code, with TestSub moved to a regular code module, it worked. -- Regards, Tim Zych http://www.higherdata.com Workbook Compare - Excel data comparison utility "E.Z." wrote in message ... Hello, Doe's "AddressOf" works with Excel macros? I keep getting a Compile Error for using it. "Invalid use of AddressOf operator" This is the code: Private Sub TestSub() i = 0 End Sub Private Function GetAddr(ByVal Addr As Long) As Long GetAddr = Addr End Function Private Sub Test() Dim Addr as Long Addr = GetAddr (AddressOf TestSub) End Sub The error is for Test Sub Tnx |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
AddressOf
Tnx a lot,
What do you mean by "regular code module"? "Tim Zych" <tzych@nospam at earthlink dot net wrote in message ... I don't have much experience with AddressOf, but from what I can see, if TestSub is moved to a regular module that should fix it. From my book "VB and VBA In a Nutshell" by Paul Lomax: AddressOf Operator Rules at a Glance: "The callback function must be stored in a code module; attempting to store it in a class or form module generates a compile-time error, "Invalid use of AddressOf operator." When I tested your code, with TestSub moved to a regular code module, it worked. -- Regards, Tim Zych http://www.higherdata.com Workbook Compare - Excel data comparison utility "E.Z." wrote in message ... Hello, Doe's "AddressOf" works with Excel macros? I keep getting a Compile Error for using it. "Invalid use of AddressOf operator" This is the code: Private Sub TestSub() i = 0 End Sub Private Function GetAddr(ByVal Addr As Long) As Long GetAddr = Addr End Function Private Sub Test() Dim Addr as Long Addr = GetAddr (AddressOf TestSub) End Sub The error is for Test Sub Tnx |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
AddressOf
In the VBE - Insert - Module.
-- Regards, Tim Zych http://www.higherdata.com Workbook Compare - Excel data comparison utility "E.Z." wrote in message ... Tnx a lot, What do you mean by "regular code module"? "Tim Zych" <tzych@nospam at earthlink dot net wrote in message ... I don't have much experience with AddressOf, but from what I can see, if TestSub is moved to a regular module that should fix it. From my book "VB and VBA In a Nutshell" by Paul Lomax: AddressOf Operator Rules at a Glance: "The callback function must be stored in a code module; attempting to store it in a class or form module generates a compile-time error, "Invalid use of AddressOf operator." When I tested your code, with TestSub moved to a regular code module, it worked. -- Regards, Tim Zych http://www.higherdata.com Workbook Compare - Excel data comparison utility "E.Z." wrote in message ... Hello, Doe's "AddressOf" works with Excel macros? I keep getting a Compile Error for using it. "Invalid use of AddressOf operator" This is the code: Private Sub TestSub() i = 0 End Sub Private Function GetAddr(ByVal Addr As Long) As Long GetAddr = Addr End Function Private Sub Test() Dim Addr as Long Addr = GetAddr (AddressOf TestSub) End Sub The error is for Test Sub Tnx |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
AddressOf
Yup, got it. works.
Tnx again |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
AddressOf limitations 2002 vs. 97 | Excel Programming | |||
AddressOf Nightmare | Excel Programming | |||
AddressOf in Excel 2002 VBA? | Excel Programming | |||
usage "AddressOf TimerProc" in Excel97 | Excel Programming | |||
AddressOf / Windows API question | Excel Programming |