Modeless window

[Jos Vens]

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

 

[Norman Jones]

Hi Jens,

Try:

AppActivate Application.Caption

 

[Jos Vens]

Terrific! It works!

Thanks a lot
Jos

Hi Jens,

Try:

AppActivate Application.Caption

 

[Norman Jones]

Hi Jos,

Thanks for the feedback and apologies for mis-spelling your name!