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

Hi Jens,

Try:

AppActivate Application.Caption

---
Regards,
Norman



"Jos Vens" <[email protected]> wrote in message
news:[email protected]...
> 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
>
>
>

Terrific! It works!

Thanks a lot
Jos


"Norman Jones" <[email protected]> schreef in bericht
news:%[email protected]...
> Hi Jens,
>
> Try:
>
> AppActivate Application.Caption
>
> ---
> Regards,
> Norman
>
>
>
> "Jos Vens" <[email protected]> wrote in message
> news:[email protected]...
>> 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
>>
>>
>>
>
>

Hi Jos,

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

---
Regards,
Norman



"Jos Vens" <[email protected]> wrote in message
news:%[email protected]...
> Terrific! It works!
>
> Thanks a lot
> Jos