MicrosoftI am an Excel VBA developer. I generally work with a large volume of data distributed across multiple workbooks. I like to use a central userform to control the application. From this userform the operator will select source files to process and, typically, will select a single target file in which to collect the results of processing.
I want that main userform to usually stay visible on top, even as the code may be opening/closing many data workbooks as part of processing. Right now, under SDI, the main userform disappears when I open another workbook. Right now I am "living" with this. The app still works but it doesn't look professional and the operator can't easily interrupt a long process, even though I have it set up (with doevents) so that he theoretically can - except the userform with my "Cancel/Abort" button is gone. There are other problems with the disappearing main userform.
I personally don't care if you use SDI, MDI, or anything in between, as long as you give me this basic functionality. And it would be nice to be able to turn off screen updates, too.
Can you give me this functionality under SDI? I can't be the only developer to feel the lack. You must have heard similar comments from others. This has nothing to do with multiple monitors or links between workbooks or any of that amateur nonsense. I store raw data in multiple workbooks. I run VBA code to process that data, going from one workbook to the next sequentially. I want to do this from a main userform which stays visible on top. Okay, I'm repeating myself. Can you give me this very basic and, I believe, very critical, functionality?
