Check box Name changing when checked

[tacnola]

I want the name of a check box to change when it is checked or unchecked. I have a box where it is working just fine. I was given assistance to the initial code and have been using that code to create the same scenario with other check boxes on my sheet, but receive errors. I have been trying to decipher the problem to no avail. Can someone look at my codes and explain why when I copy the same formula it is not working.

The UN-Check All / Check All button is the working check box.
I am trying to apply the same function to the four boxes next to Check Date and GL Post date fields.
I have reset all codes except for the last check box #34, which I have left so the error can be looked at.
What I want it to do is when checked I want the name to be "Payroll GL Post Date" When Un-checked the name should be "Adjustment GL Post Date"
Thank you for any assistance that can be provided.


Teresa

[seckert]

The problem is you have the ".shapes" selection inside the "with" statement. Try the following:

Please Login or Register  to view this content.

[tacnola]

Thank you!! That worked great!