samuelwright
12-09-2005, 04:21 AM
Helloo!!
I apologise for moving this problem into a new post, but is was moving along a different direction than the original problem I had in an old post:
I am having a problem in viewing a userform when I click a button that has been added to a New Message Toolbar
The facts are:
1. Word 2003 is selected as the default message editor.
2. When Outlook starts, some VBA posts a new button onto the New Message toolbar.
3. This new button is programmed to load and show a userform which outputs a string into the Subject Line of the message.
Here is the problem:
1. When I click the button, the form loads, but it does not show in front of the New Message, but behind it (ie in terms of window layers it goes Outlook Inbox-UserForm-New Message!)
I dont want to have to minimise the New Message window to show the UserForm. Is there any way of bringing the Userform to the front? I have tried putting a userform.visible in the Initialize event, and in the class module but to no avail. I attach the VBA Project below.
PS this is not a problem when Word is not the default message editor...
PPS a lot of this code is from an excellent KB entry by MOS MASTER...a wonderful person and probably an actual genius:clap: check it here:
http://www.vbaexpress.com/kb/getarticle.php?kb_id=502
I apologise for moving this problem into a new post, but is was moving along a different direction than the original problem I had in an old post:
I am having a problem in viewing a userform when I click a button that has been added to a New Message Toolbar
The facts are:
1. Word 2003 is selected as the default message editor.
2. When Outlook starts, some VBA posts a new button onto the New Message toolbar.
3. This new button is programmed to load and show a userform which outputs a string into the Subject Line of the message.
Here is the problem:
1. When I click the button, the form loads, but it does not show in front of the New Message, but behind it (ie in terms of window layers it goes Outlook Inbox-UserForm-New Message!)
I dont want to have to minimise the New Message window to show the UserForm. Is there any way of bringing the Userform to the front? I have tried putting a userform.visible in the Initialize event, and in the class module but to no avail. I attach the VBA Project below.
PS this is not a problem when Word is not the default message editor...
PPS a lot of this code is from an excellent KB entry by MOS MASTER...a wonderful person and probably an actual genius:clap: check it here:
http://www.vbaexpress.com/kb/getarticle.php?kb_id=502