i just found out that the callback mechanism relies on application.enableevents being set to true in excel/vba.
that's why i'm asking you to provide me with an efficient synchronous query mechanism.
in sophisticated excel/vba tools, users often need to set the enableevents to false.
callback is very good in multithreaded(actor) languages like c#/java/scala... but not very convenient in excel/vba when users do need to do certain synchronous batch query.
Please provide me a good sample of how to efficient synchronous query in vba asap.
thank you very much,
I'm afraid you are mistaken. Please see my response to your comment on the original thread.