Results 1 to 8 of 8

Thread: Userform does not show when I tell it to! Bad UserForm!!!

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #5
    Hi all, happy new year!

    Sorry have not got back earlier, been away for crimbo!

    Gerry: the order goes

    1. When new message (or reply/forward) is opened in Outlook, VBAProject puts a new button on taskbar
    2. This button, when clicked, opens a userform, with fields to write to subject line etc
    Therefore, new message is opened first, then userform

    Killian

    Yes you are right, I think. I have tried the following bit of code, which does not solve the problem in the way I want, but it kind of removes the symptoms if Word is the editor...ish

    If ActiveInspector.IsWordMail = True Then 
        Application.ActiveInspector.WindowState = olMinimized
        SubjectNameForm.Show
        Exit Sub
        If ActiveInspector.IsWordMail = False Then
            SubjectNameForm.Show
        End If
    The message window is then maximised again once the userform is completed. Probably not the greatest work of VBA you will ever see
    Last edited by Aussiebear; 02-08-2025 at 01:02 AM.
    Sam

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •