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,