Message Box and Selection Change

  • Hello: I'm creating a template in which all cells must be filled out before a macro can be run. The current coding I have creates a message box anytime I click on a cell and the required cells have not been filled in. I would like for the message box only to appear after the template has been filled out so it will reveal anything the employee may have forgot to input. I tried disabling events and then re enabling them at the end but that didnt really work so Im hoping someone has ideas.

  • Re: Message Box and Selection Change

    I think I'm confused as to what you are trying to accomplish. First, you want to use this sub so it doesn't fire every time you select a new cell:

    Second, wouldn't it make more sense to put this validation at the start of your macro?

Participate now!

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