Thread: Modeless window
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jos Vens[_2_] Jos Vens[_2_] is offline
external usenet poster
 
Posts: 134
Default 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