Excel "De-Prioritizing" Itself

[FitOne3539]

First off, I'll let you know I'm programming in VBA in Excel. I'm prompting the user with multiple dialog boxes, getting selections, but Excel keeps "de-prioritizing" itself behind other applications I have open. For example, I prompt the user, they make a selection, hit "Okay", then another application will pop up in front, and Excel will be in the background flashing, trying to let me know that it's ready for the user to make another selection, which is another dialog box. Is there any way to KEEP Excel in front? I'd appreciate any help I can get because this has been driving me crazy! Thanks!

Greg II

[vass0922]

do you have an instance of the Excel application?
If so you can set the instance property to true to make sure its in front.
for instance..
excelapp.Visible = True

I'll see if I can come up with something else.

[Creosote]

You'd have to paste the code. I just tried an example, using both a created form and built-in Excel dialog boxes both (you didn't say which you were using) and upon the unload (of the created form anyways) it would return to Excel.

[FitOne3539]

What I'm doing is having the user select a group of items, and datbases are being checked to see what tests exist for each particular item. A test will come up in a VB form, be selected by the user, then it goes through a macro to store that data in an array. Then tests for the next construction are displayed, and so on. Sometimes, all the VB forms will come up without me having to "reactivate" Excel, and other times, one of the other applications running will jump up in front, and the Excel button will flash on the toolbar. If data doesn't exist for the item, a message box comes up and says say (with a vbOKonly), after which the program will move onto the next item. I've found that, on occasion, I can minimize the application that pops up, and control is returned back to Excel.

As far as the 'instance' stated by vass0922, I can't do anything with that in VBA. I tried doing a search, and it didnt' know what I was talking about.

I also tried unloading the forms, but it still functions the same way.

Appreciate the help, but still stuck, though.