Help Writing Code for Command Button

I'm am looking to understand what code needs to be entered to produce the following scenario. I'm sure it's suer simple, I am just uncertain myself.

I'd like one command button that when pushed toggles the text in one cell between "YES" and "NO". Also, When pressed I'd like the text displayed on the command button itself to correspond with the populated cell to match ("YES" or "NO").

Thanks!

I've attached a workbook with what you described. A couple of notes if you want to do this yourself:

1) I prefer using shapes to create buttons for running my macros instead of command buttons. There are so many quick formatting options available that make them look so much nicer than the "we're still in the 90s" gray command buttons. This method will work for either though, so do as you choose.
2) If you click on a shape or textbox, or anything of that sort to put focus on it and then type a formula in the formula bar, it works just like a cell formula. With this, you can set the text on the button equal to the text in the cell you will be changing.
3) I used a named range called "YesNo" for the cell that will be toggled.
4) Here is the code that you will need to make this work (this code assumes the cell being changed is in the same tab as the button itself):

Please Login or Register  to view this content.

Let me know if you have any questions.

Originally Posted by brant.wheeler

I've attached a workbook with what you described. A couple of notes if you want to do this yourself:

1) I prefer using shapes to create buttons for running my macros instead of command buttons. There are so many quick formatting options available that make them look so much nicer than the "we're still in the 90s" gray command buttons. This method will work for either though, so do as you choose.
2) If you click on a shape or textbox, or anything of that sort to put focus on it and then type a formula in the formula bar, it works just like a cell formula. With this, you can set the text on the button equal to the text in the cell you will be changing.
3) I used a named range called "YesNo" for the cell that will be toggled.
4) Here is the code that you will need to make this work (this code assumes the cell being changed is in the same tab as the button itself):

Please Login or Register  to view this content.

Let me know if you have any questions.

Thank you Brant! I've got the functionality I'm looking for to work (the part where the desired cell toggles back and forth from YES to NO) but I can't seem to get the text on the command button box to correlate. Can this maybe be done through the properties?

Originally Posted by brant.wheeler

ou will need to make this work (this code assumes the cell being changed is in the same tab as the button itself):

Please Login or Register  to view this content.

Since you are using a Defined Name for the toggle cell, your macro can be simplified quite a bit...

Please Login or Register  to view this content.

Super simple, flip-flop the command button actions.

Please Login or Register  to view this content.

Originally Posted by Rick Rothstein

Since you are using a Defined Name for the toggle cell, your macro can be simplified quite a bit...

Please Login or Register  to view this content.

Originally Posted by torachan

Super simple, flip-flop the command button actions.

Please Login or Register  to view this content.

Thank you guys!! I was able to get it to work!