Thread: UserForm
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
steven steven is offline
external usenet poster
 
Posts: 389
Default UserForm

I have a UserForm that has a listbox which has the names of files that are
open. When the user clicks an item in the listbox it will go to that file
with:

Workbook(wb).Activate

But the UserForm still has the focus. I have to actually click on the
workbook window to get the scroll to work. How can I get the focus to the
File window from the UserForm after the Workbook(wb).Activate command in the
UserForm without closing the UserForm or doing an Unload UserForm?

Thank you,

Steven