VBA and Non-Modal Windows

[CoreyS]

Hello All,

Just wondering if anyone knows if there is a way around the Non-Modal limitation of VBA. I guess it makes sense that you cannot create non-modal windows, but I wanted to be able to create a non-modal child window from a script. I tried creating an ActiveX .DLL with a Non-Modal window and calling it from the VBA engine (Sax to be specific) and I got an error.

Alternatively I was thinking; Is there a way to create a window using API calls and have that window do it's own thing without VB running? For example, I would like to be able to create a window that has a button and have that button call another function (maybe an API call) without having the original VB App that created the window running?

Thanks for ANY ideas!

[da_silvy]

i don't understand, what do you mean by non-modal?

[CoreyS]

Another way of saying Non-Modal is Modeless, Non-Modal windows are windows that do not require them to be closed before processing continues. For example, when you use MSGBOX it launches a MODAL window, you can tell because you have to hit OK to continue on with what you are doing. Also if you show a form with the 1 command (ie frmForm.Show 1) it will be displayed in a Modal format, leave it blank (ie frmForm.Show) and it will be displayed in a Non-Modal format.