Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Modeless window
Hi,
Is it possible when you open a modeless window (userform) to give the focus back to the sheet you were working in, without waiting for a click of the user in the sheet. This lines did not do the job: Set vSheet = ActiveSheet myForm.Show False vSheet.Select or vSheet.Activate Thanks Jos Vens |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Modeless window
Hi Jens,
Try: AppActivate Application.Caption --- Regards, Norman "Jos Vens" wrote in message ... Hi, Is it possible when you open a modeless window (userform) to give the focus back to the sheet you were working in, without waiting for a click of the user in the sheet. This lines did not do the job: Set vSheet = ActiveSheet myForm.Show False vSheet.Select or vSheet.Activate Thanks Jos Vens |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Modeless window
Terrific! It works!
Thanks a lot Jos "Norman Jones" schreef in bericht ... Hi Jens, Try: AppActivate Application.Caption --- Regards, Norman "Jos Vens" wrote in message ... Hi, Is it possible when you open a modeless window (userform) to give the focus back to the sheet you were working in, without waiting for a click of the user in the sheet. This lines did not do the job: Set vSheet = ActiveSheet myForm.Show False vSheet.Select or vSheet.Activate Thanks Jos Vens |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Modeless window
Hi Jos,
Thanks for the feedback and apologies for mis-spelling your name! --- Regards, Norman "Jos Vens" wrote in message ... Terrific! It works! Thanks a lot Jos |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
The window opens in a smaller window not full sized window. | Excel Discussion (Misc queries) | |||
VB6 COM Add-In and Modeless Dialogbox | Excel Programming | |||
modeless userform | Excel Programming | |||
Modeless Wait ? | Excel Programming | |||
modeless userforms | Excel Programming |