| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
UserForm
userform1.hide should do it
"Steven" wrote: 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
UserForm
Thank you for the response. That hides it but I want the form to show all
the time. I tried: UserForm1.Hide UserForm1.Show but this hangs up the system, which makes sense. Is there another way to get the focus to the selected file but keep UserForm1 showing and still available? There are many files open that can be selected. UserForm1 is a form in one of the files (a control file.) Thank you, Steven "dmoney" wrote: userform1.hide should do it "Steven" wrote: 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
UserForm
Have you tried userform1.showmodal=false
"Steven" wrote: Thank you for the response. That hides it but I want the form to show all the time. I tried: UserForm1.Hide UserForm1.Show but this hangs up the system, which makes sense. Is there another way to get the focus to the selected file but keep UserForm1 showing and still available? There are many files open that can be selected. UserForm1 is a form in one of the files (a control file.) Thank you, Steven "dmoney" wrote: userform1.hide should do it "Steven" wrote: 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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
UserForm
Yes, UserForm1.Show False
"dmoney" wrote: Have you tried userform1.showmodal=false "Steven" wrote: Thank you for the response. That hides it but I want the form to show all the time. I tried: UserForm1.Hide UserForm1.Show but this hangs up the system, which makes sense. Is there another way to get the focus to the selected file but keep UserForm1 showing and still available? There are many files open that can be selected. UserForm1 is a form in one of the files (a control file.) Thank you, Steven "dmoney" wrote: userform1.hide should do it "Steven" wrote: 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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
UserForm
not .show, .showmodal
"Steven" wrote: Yes, UserForm1.Show False "dmoney" wrote: Have you tried userform1.showmodal=false "Steven" wrote: Thank you for the response. That hides it but I want the form to show all the time. I tried: UserForm1.Hide UserForm1.Show but this hangs up the system, which makes sense. Is there another way to get the focus to the selected file but keep UserForm1 showing and still available? There are many files open that can be selected. UserForm1 is a form in one of the files (a control file.) Thank you, Steven "dmoney" wrote: userform1.hide should do it "Steven" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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 | |||
Hybrid Mode
