re: To VBA and beyond - building a RESTful backend using plain Microsoft Excel macros VIEW POST

FULL DISCUSSION
 

This may not be ideal but if you call DoEvents in VBA your user interface will not be blocked. Though keeping a macro running indefinitely may be a bad idea.

 

I haven't seen DoEvents, yet. I just added it and now the GUI isn't blocking anymore, thus you could kill the server from the VBA window, too. Thank you!

code of conduct - report abuse