Switching Application Displayed On Screen

[f64]

I am developing a computer simulation in SIMUL8 together with a userform in Excel to input configuration data and draw graphs of results. When “Finish” is clicked on the Excel Userform, VB calls the simulation, the simulation imports the configuration data and executes, and upon completion passes results data back to Excel to draw a graph. Currently the Excel spreadsheet remains displayed on screen while the simulation executes. I would like the screen display to switch to the simulation during execution so that the animation is visible, and then upon completion of the simulation switch back to the graph in the Excel spreadsheet. Is this controllable in VB?

 

[BiggerBrother]

If you know the name of the application you want to show, then use AppActivate to bring the required application to the front of the screen.

Search this forum for a few good examples of how to use.

AppActivate myApp - will bring myApp to focus.

BB

 

[PHV]

Or you can try to play with Application.WindowState in your Excel VBA code.

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884