Can someone explain how to transfer control (focus) to the Exce
Spreadsheet
temporarily, while continuing to have a VBA Form running in th
background?

In Visual Basic I used to do this with the SetWindowPos function foun
in
the Windows "user32" API.

In VBA I don't know how to address window handles and keep my VBA Form
running. I am forced to exit my VBA code entirely if I want to d
anything
in the Excel form itself.

Thank

--
Tony LeGran
-----------------------------------------------------------------------
Tony LeGrand's Profile: http://www.officehelp.in/member.php?userid=504
View this thread: http://www.officehelp.in/showthread.php?t=125710

Posted from - http://www.officehelp.i