Auto select Marlett Checkboxes

[escobf]

In my workbook, I have implemented Marlett checkboxes in ColumnB of Sheet(1) tabls(A) to activate the checkbox feature if the table row is not empty (its a table with thousands of rows that are filled via formulas).

The code for the checkboxes works great, however my issue is that since the table is linked to a table(B) on a another sheet(2)- whenever data is added/deleted the 'checked' checkboxes are no longer corresponding to the correct rows.
My on going idea to address this is to record 'checked' checkbox rows from Sheet(1) table(A) to the data in Sheet(2) table(B). Then insert a formula in ColumnA next to the checkboxes in Sheet(1) table(A) that essentially looks up the recorded 'checks' in Sheet(2) Table(B).

Basically, to simplify my issue, how can I auto select a Marlett checkbox if the value in its adjacent column is not blank?

My checkbox code is:

Please Login or Register  to view this content.

I tried adding variations of:

Please Login or Register  to view this content.

However this does not do anything; I think what I need will likely be in a new Sub..

[arlu1201]

Is this solved?

If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.