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

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

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

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