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.

Hi GrahamUNC,
AppActivate "Title caption form you want activate"
MP

"GrahamUNC" <cngraham@gmail.com> a écrit dans le message de news:
1113590134.885443.213560@o13g2000cwo.googlegroups.com...
> 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.
>

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" <cngraham@gmail.com> a =E9crit dans le message de news:
> 1113590134.885443.213560@o13g2000cwo.googlegroups.com...
> > 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.
> >