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

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

Try this as a worksheet_chang event. Make sure your button names correspond with the column (so "button 1" in column 1, "button 3" in column 3 etc.):

Please Login or Register  to view this content.

Please click the * below if this helps

MINION

Its working. Wait

As below.
Sample 8.xls
Just so to set your expectations straight, this does NOT:

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.

It does change the button caption - because that's what you asked

Please remember to click the * below if this helps

I attached the wrong sample...
See the right one below

SampleProblem.xlsb

Originally Posted by JasperD

I attached the wrong sample...
See the right one below

Attachment 267508

Sorry Jasper, I am late to response again. I just re-edit my reply since it is working. But I seen a problem.

This is the problem, because when ever I type and edit other cell. There is a MsgBox says "The Item with the specific name wasn't found". And I seen it is limited to check the rows of the table, when ever I add another row again, it is not working and MsgBox is always popping.

This is the file with my code and your code: EDITED
SampleSample.xlsb

Is this problem possible to limit the macro into the table and to the buttons?

Is this possible the WorkSheet_Change macro will be limited in the TABLE only.