[SOLVED] VBA Changing button.caption in a specific cell column

[mcmunoz]

I have a problem about cell through buttons.

SITUATION:
I have a table and a button in my worksheet.

MACRO:
If I doubleclick a cell it will put "CHECK" so on and so for... then I have a button that will entire column will be "CHECK" where ever the button is place in which column.

THE PROBLEM IS: - please help
I want to change the BUTTON.caption when a user ERASE at least only 1 "CHECK" in the table then the button CHANGE name also.

Flow:
If x = x Then

button.caption = "uncheck all"

Else

button.caption = "check all"

End If

WHY I WANT THAT:
Because to inform the user that there is UNCHECK MARK in the column of the table. They will notice that a BUTTON.caption change.

PLEASE SEE ATTACHMENT BELOW:
SampleProblem.xlsb