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
|