View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Michel Pierron Michel Pierron is offline
external usenet poster
 
Posts: 214
Default 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.