ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Async UDF (https://www.excelbanter.com/excel-programming/410928-async-udf.html)

Steve Lloyd[_2_]

Async UDF
 
Hello.

I am trying to create a Asyncronous UDF. I have created the UDF call and
have created the async call using a delegate and .BeginInvoke and setting a
callback. The callback works and raises an event with some custom eventargs
that will return the info back into Excel

I have create a className_EventHandler(customEventArgs) sub routine but it
does not get launched. The plan was to send the cell reference with the
async call and then add this to the eventargs to populate the appropriate
cell. However, this is not working.

Can anyone help or point me in the right direction of some useful tips.

Thanks very much for any help.

Steve Lloyd



Steve Lloyd[_2_]

Async UDF
 
Sorry all, this was a little premature. Have fixed it now.

Thanks anyway.

"Steve Lloyd" wrote in message
...
Hello.

I am trying to create a Asyncronous UDF. I have created the UDF call and
have created the async call using a delegate and .BeginInvoke and setting
a callback. The callback works and raises an event with some custom
eventargs that will return the info back into Excel

I have create a className_EventHandler(customEventArgs) sub routine but it
does not get launched. The plan was to send the cell reference with the
async call and then add this to the eventargs to populate the appropriate
cell. However, this is not working.

Can anyone help or point me in the right direction of some useful tips.

Thanks very much for any help.

Steve Lloyd





All times are GMT +1. The time now is 11:40 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com