Trying to implement a Global Variable in VBA

Hello,

Currently I have a submit button macro that moves a selected range of cells from one sheet to a protected sheet of compiled data. I also have an undo button macro that deletes the last submission from the protected sheet.

I only want the undo macro to be able to run once before the submit macro is run again. Is there a way to implement a global variable such that the undo macro only runs if the variable is on?

The variable would be set to off at the end of the undo macro and turned on after the submit macro.

How can this be done? Any help would be greatly appreciated.

How do I edit the enabling property of the button?

How do I edit the enabling property of the button?

If the name of the button is MyButton then

Please Login or Register  to view this content.

This also works with just about any control.

So I have two buttons each with their own macro --> Button1 (submit) and Button2 (undo)

Within the code for Button1, I have:
Button2.Enabled = True

and within the code for Button2 I have:
If Button2.Enabled = False Then Exit Sub

and also at the end of the code

Button2.Enabled = False


From what I understood, this is what you told me to do however it still is not working...I get error messages when I run either the submit macro or the undo macro.

Do you know why?

When asking for help regarding error messages it's always a good idea to include the error message, plus note which line of code is causing the error.

What you wrote here looks mostly correct, although this code is unnecessary:

Originally Posted by adam2742

and within the code for Button2 I have:
If Button2.Enabled = False Then Exit Sub

If Button2 is not enabled, the user can't press it and this code will never execute. Unnecessary, but it won't cause a problem.

I would suggest you post all of your code, or better yet, attach your workbook.

Also, there is a rule for posting code:

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here