Swap button text

I have a forms control (VBA) button that, when clicked, I'd like to test the value written on the button, and perform an action, then change what's written on that button (to show what action was taken). When the button is clicked a second time, I'd like to reverse the process, i.e, test the value written on the button, reverse the previous action, then replace the button text with the original text. Because I cannot know when opening the file what the state of the button is, I feel that each time I press the button I should test the state of the button so that I perform the proper action.

Maybe something like this? Assign the macro to the button

Please Login or Register  to view this content.

When I use this code I get the Variable not defined message with the word "Buttons" highlighted on the second line of code.

Maybe post a sample of your workbook. The code should be in a worksheet to work. If you are putting them in a module, you need to reference with that worksheet.buttons. I also attached a sample.

This worked out great. I was a bit confused at first about how the buttons are referenced, but it seems they are Buttons(1) ,(2), (3) etc. in the order they are created on the worksheet rather than by the button number the label says.