How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • Go back-and-forth until satisfied
    Rate the answer you receive.
Ask Alex Royce Your Own Question
Alex Royce
Alex Royce,
Category: Microsoft
Satisfied Customers: 2496
Experience:  Technical Consultant at Prism
104779581
Type Your Microsoft Question Here...
Alex Royce is online now

I'm looking to create a pop up via VBA on an excel document

Customer Question

Hello, I'm looking to create a pop up via VBA on an excel document that will automatically dismiss itself to allow the rest of the macro to run, which is to close the workbook without saving at 1:25pm every day. Is this possible?
Submitted: 7 days ago.
Category: Microsoft
Expert:  Alex Royce replied 7 days ago.

Hello my name is ***** ***** it is a pleasure to be able to assist you here today. This is not the easiest of queries due to their being so many different variables. However the good news is Microsoft have published an official "to do" on this very query. Please go to; https://docs.microsoft.com/en-us/office/vba/excel/concepts/controls-dialogboxes-forms/automatically-dismiss-a-message-box and it will make it quite easy for you.

Thank you

Alex