| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Transferring Control From VBA Form to Spreadsheet
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 2007 Form Control/ActiveX Control font difference | Excel Discussion (Misc queries) | |||
| Transferring from one form to another | Excel Discussion (Misc queries) | |||
| Opening a workbook withAuto-open Macros without transferring control | Excel Programming | |||
| Transferring information from one user form to another | Excel Programming | |||
| Spreadsheet Control on User Form | Excel Programming | |||
Threaded Mode
