Yes/no interactive message box

  • Is it possible to have an interactive yes/no message box which gives uses a the "yes" option of viewing the message again or the "no" option of disabling the message box so that it does not appear again? If so, I would really appreciate advice on the coding.
    The message box would be triggered by a worksheet open event procedure.
    Ian

  • Re: Yes/no interactive message box


    Like this/

  • Re: Yes/no interactive message box


    Roy
    Many thanks for the reply. I have just pasted the code into a workbook and it doesn't work. Probably I am missing something - can you advise/
    Ian

  • Re: Yes/no interactive message box


    Roy
    I was partially doing something stupid! The code is fine, but is it possible to disable a message box completely on selecting "No", so that it never appears again when the workbook is opened or worksheet activated?
    Ian

  • Re: Yes/no interactive message box


    Thanks for the reply Roy. I wanted the kind of dialogue or message box along the lines of the "accept terms and conditions" box that appears when software is used for the first time. I guess from what you are saying that this is not possible using visual basic.
    If you could give me an example of code that disables the message box macro by selecting no - referencing to a remote cell, as you suggest and/or any other way in which I can disable the macro that selects the message box.
    Ian

  • Re: Yes/no interactive message box


    Hi Roy
    I woke up thinking about this with the code in my head! Obvious really! But your prompt about the reference cell was a very helpful reminder. Many thanks again.
    Ian

  • Re: Yes/no interactive message box


    That's what i meant, but it was late for me last night so I didn't have time to code it. This is a little shorter:

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!