DEV Community

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

View post

Replies for: 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...

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!