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!