How can I run a VBA Macro or VBA Subroutine form spBasic?
See the Developer’s Page -How to use VBA with spBasic. I have a Msgbox statement in a VBA macro I’m calling from spBasic. While debugging the program the message box was displayed behind the Debug Form and I couldn’t get at it. I had to use Ctrl-Alt-Del to stop Excel and start over. SpBasic Windows will normally stay on top of the Excel window. Excel treats VBA as part of it’s window, so you have to be careful if you’re using a VBA messagebox or an input form at the same time that an spBasic window is displayed. If you use a message box from VBA, and a spBasic window is showing (Edit Form. Help, etc.) , the msgbox might appear behind the window. Press ‘Enter’ or ‘Esc’ to terminate the msgbox and return control to the spBasic form. To avoid this situation, keep the spBasic windows off to the side when you’re debugging a VBA routine containing a msgbox or input form, or minimize the Edit form and create a Run button to run the program ( run the program from the ‘Run’ button).. This is al
