How to stop user form from disapearing once mail window is closed?

Status
Not open for further replies.

AllNamesAreTaken

New Member
Outlook version
Outlook 2019 64-bit
Email Account
Office 365 Exchange
Hello,

My Outlook VBA code causes a UserForm to pop up at specified times during the day (triggered by the reminders). When it does, the user needs to take action or may close it, depending on the information displayed on that UserForm.

I need to have the possibility to navigate through Outlook while UserForm is still visible. I made it happen by setting ShowModal = False - it's done by one of the buttons (I did not set it straight away in the user form settings as it is important to get user's attention by blocking the application).

Now, there are 2 scenarios:
  • The moment the form pops up, the user is at the main pane (where are all emails, folders). If the form pops up there, user can unfreeze it with button (change of modality setting), then create new email, then send that email (or close or save) and the pop up will still be there in the main pane, waiting to be closed by the different button. This scenario works fine.
  • The moment the form pops up, the user is at the mail view (either writing new email, or just looking at one opened). Then if the pop up shows in that view and user closes that email or sends it, pop up disappears as well.
I would like to achieve either of the two:
a) The pop us shows up always in the main pane, regardless of the current view of the user (he will see it once he goes to the main pane if he's in the middle of writing the email). I think it can conflict with modality set to true at the beginning.
b) The UserForm stays visible regardless if email view is closed (or as long as given button is not clicked).

Could anyone help?

I think the solution may be related to UserForm_QueryClose, as when window view is closed (email sent or closed), this QueryClose is trigerred.

Currently I have the following coder there:

Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)
If CloseMode <> 1 Then
MsgBox "Use a button to close this userform."
Cancel = True
ResultsForm.Hide
ResultsForm.Show
End If
ResultsForm.Hide
ResultsForm.Show
End Sub
I've tried different combinations of Show/Hide properties, however UserForm still closes and is not visible after mail view is closed, even though I receive the msgbox trigerred by that closure.

I have also tried to use ResultsForm.CommandButton1.SetFocus to regain view of the UserForm once Outlook email window is closed, however it does not work.
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
Victor_50 Problem - Google Workspace will stop "unsafe" access to Outlook end 2024 Using Outlook 3
L How Stop Outlook Nag Messages Using Outlook 1
G Stop Outlook 365 adding meetings to calendar Using Outlook 1
L Emails being archived when I press the A key accidentally - how do I stop this? Using Outlook 0
P How can I stop Outlook 365 duplicating the posts? Using Outlook 1
J how to stop junk emails from *.onmicrosoft.com ? Using Outlook 2
D Outlook 2016 Outlook Error Msg "The operation cannot be performed ..." How to Stop it Using Outlook 4
T "Words In Recipient's Address" Rule Causes Outlook To Stop Processing Rules Using Outlook 3
Y Outlook 2013 Stop Outlook from automatically assigning categories to Tasks Using Outlook 0
D Any updates or fixes that would make this code stop working just moving emails to another folder Outlook VBA and Custom Forms 1
F Outlook 2016 call to Stop Timer Event Outlook VBA and Custom Forms 4
S stop calendar date reverting to today Using Outlook 7
B Contacts just stop syncing, yesterday... Using Outlook 4
O Stop more than one person responding to an email? Using Outlook 1
A Stop Rule (not turn off) that Delays Outgoing Items Outlook VBA and Custom Forms 1
A Can't stop Outlook.com from setting reminders on appointments? Using Outlook.com accounts in Outlook 3
D Stop meeting acceptance notifications Using Outlook 1
J it goes like outlook has stopped working, a problem caused the program to stop working correctly, wi Using Outlook 2
makinmyway Research Pane in Emails Turns on and Cut Paste Keys then Stop Working Using Outlook 5
J How to Stop OutLook from being Installed Using Outlook 1
A Exchange 2003 how to stop accepting EHLO and AUTH commands Exchange Server Administration 2
M Outlook 2010 IMAP rules occasionaly stop working Using Outlook 4
C How to stop iCloud calendars opening by default Using Outlook 8
icacream outlook 2007 - how do I stop spacing when I hit return ? Using Outlook 4
T Outlook 2007 SSL selfsigned certificate how to stop security popup everytime? Using Outlook 10
Y How do you stop double booking? Using Outlook 1
Commodore Why some RSS feeds stop getting updates? Using Outlook 12
N Rules stop running automatically Using Outlook 10
S Stop mail checking Using Outlook 5
M Can you stop "Microsft Office Outlook is synchronizing folders"? Using Outlook 2
C stop messages to personal folders Using Outlook 2
M Why rules stop running automatically? Using Outlook 1
J Stop Outlook 2010 from showing face pictures in From/To/Cc/Subject box Using Outlook 2
S Shared Calendar Need To Stop Receiving Other Peoples Reminders Using Outlook 3
R Stop Double Booking Rooms Using Outlook 3
C stop facebook? Using Outlook 16
A How do I get Outlook to stop adding a "+1" in front of a telephone number that has an extension. Using Outlook 13
L Outlook inbox is "always in front". How to stop that? BCM (Business Contact Manager) 1
M Stop Search folders from disabling every 1-2 days? Outlook VBA and Custom Forms 3
N VBA Procedure (or Macro) to Stop Outlook from Closing? Outlook VBA and Custom Forms 2
M Stop ribbon item tool tip text from wrapping? Outlook VBA and Custom Forms 2
D Stop automatic opening BCM (Business Contact Manager) 1
C How to stop replies in thier tracks Outlook VBA and Custom Forms 1
A stop outlook reminders generated through BCM BCM (Business Contact Manager) 3
D Lifelong Windows user - new to Mac - Help!!! Using Outlook 3
Witzker Outlook 2019 Macro GoTo user defined search folder Outlook VBA and Custom Forms 6
W OL giving basic auth when logged in to Win as specific user Using Outlook 0
Witzker Outlook 2019 How to get a Photo in a User Defined Contact form Outlook VBA and Custom Forms 2
Witzker Outlook 2019 Macro to send an Email Template from User Defined Contact Form Outlook VBA and Custom Forms 0
Witzker Outlook 2019 Edit contact from email does not open the user defined contactform Using Outlook 3

Similar threads

Back
Top