Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Switch focus to inactive userform
Hello,
I am having difficulty with 2 modeless user forms. They are both displayed at the same time and I need to switch the focus from one to the other through VBA. It doesn't work to just use the setfocus property of one of my controls on the other form to make it active. Any thoughts? Thanks in advance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Switch focus to inactive userform
Hi GrahamUNC,
AppActivate "Title caption form you want activate" MP "GrahamUNC" a écrit dans le message de news: ... Hello, I am having difficulty with 2 modeless user forms. They are both displayed at the same time and I need to switch the focus from one to the other through VBA. It doesn't work to just use the setfocus property of one of my controls on the other form to make it active. Any thoughts? Thanks in advance. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Switch focus to inactive userform
Great! It works perfectly. That was driving me crazy for the longest
time. Michel Pierron wrote: Hi GrahamUNC, AppActivate "Title caption form you want activate" MP "GrahamUNC" a écrit dans le message de news: ... Hello, I am having difficulty with 2 modeless user forms. They are both displayed at the same time and I need to switch the focus from one to the other through VBA. It doesn't work to just use the setfocus property of one of my controls on the other form to make it active. Any thoughts? Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Object on userform can't get focus | Excel Programming | |||
How do I switch focus from a modeless user form back to the excel. | Excel Programming | |||
Show userform without it taking focus? | Excel Programming | |||
Focus on Control before UserForm(s) pop up | Excel Programming | |||
UserForm Loss Focus | Excel Programming |