View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] proteus815@gmail.com is offline
external usenet poster
 
Posts: 3
Default Returning User Control to Excel from other Application in VBA

Hi.

I'm using Excel VBA to control both Excel and another application.
However, there are times when I want to control whether Excel or the
other application is the 'active' application and the one displaying on
the screen. (I pop up a user form in Excel, but the user has to click
Excel in the windows toolbar to activate it before they see the form).

How do I return control back to Excel from the other application?

Thanks!