My bad. I appoligize. Regardless, your code is working fine. I just changed this part from:
to this:Code:If x > 0 Then
And that seems to cancel out the 2 controls that autopopulate when the form is opened and doesnt trigger the yes/no prompt in your code when the close button is clicked. Perfect! THanks again, My Aswer Is ThisCode:If x > 1 Then![]()
Well if that works for you great.
I think you will find if one of the other Textboxs have a value in them other then the one you wanted excluded you will not get a warning message.
So for example if the textbox you wanted excluded is empty but TextBox4 has a value in it the script will not give you a warning.
If that proves true you will have to get back with me.
Last edited by My Aswer Is This; Oct 3rd, 2018 at 03:02 PM.
Be sure and always test this script on sample data the first time you use this as to avoid any problems with your data. Always trying to learn more and help others where I can. I'm using Excel 2013.
Patience please I’m not perfect yet. "Memories are forever"
Like this thread? Share it with others