Userform losing focus

R

red6000

Hi I'm using Word 2002 and have a macro that runs a series of UserForms.

Now when the 'user' switches to another application to get the details that
they need to enter into the UserForm, if they click on the word sesesion in
the taskbar, then the document has focus and the userform cannot be seen, so
in order to get to the UserForm, they have to ALT+TAB back to the Word
session and then th UserForm appears.

Is there any code that I can put in to keep the UserForm with focus when
switching back to Word by clicking on the taskbar session of Word?

Thanks.
 
W

Word Heretic

G'day "red6000" <[email protected]>,

If you are using magic forms, don't

Magic form eg

Load UserForm1



Proper form eg

Dim MyForm as UserForm1
Set MyForm = New UserForm1

MyForm.Show

Set MyForm = Nothing


Steve Hudson - Word Heretic

steve from wordheretic.com (Email replies require payment)
Without prejudice


red6000 reckoned:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top