Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Is there an easy Copy/Paste of a Userform ? (Entire Userform Including tx & cbx's) | Excel Programming | |||
Userform to enter values and shown in same userform in list | Excel Programming | |||
Looping procedure calls userform; how to exit loop (via userform button)? | Excel Programming | |||
Activating userform and filling it with data form row where userform is activate | Excel Programming | |||
Access from add_in userform to main template userform.... | Excel Programming |