callback in VBA relies on application.enableevents being set to true

Hello,

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,

jude jin