DEV Community

Discussion on: To VBA and beyond - building a RESTful backend using plain Microsoft Excel macros

Collapse
 
blonkm profile image
Michiel van der Blonk •

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.

Collapse
 
michaelneu profile image
Michael Neu •

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!