Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Programming / February 2006

Tip: Looking for answers? Try searching our database.

Userform losing focus

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
red6000 - 05 Feb 2006 14:55 GMT
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.
Word Heretic - 14 Feb 2006 13:58 GMT
G'day "red6000" <red1000002001@yahoo.com>,

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:

>Hi I'm using Word 2002 and have a macro that runs a series of UserForms.
>
[quoted text clipped - 8 lines]
>
>Thanks.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.