Beneindias
Board Regular
- Joined
- Jun 21, 2022
- Messages
- 97
- Office Version
- 365
- Platform
- Windows
- MacOS
I have an excel file with table that has checkboxes for each row in column B.
When I delete a row, the checkbox that was there, looses it's linked cell.
So, is there any way that I can check if linked cell has a cell, or if it's an "#Ref" error?
I need to check if LinkedCell is an error, and if it is, delete that checkbox.
I was trying this code, but it doesn't work.
Also tried this code, but this one gives me an error:
"Run-time error 438:
Object doesn't support this property or method"
When I delete a row, the checkbox that was there, looses it's linked cell.
So, is there any way that I can check if linked cell has a cell, or if it's an "#Ref" error?
I need to check if LinkedCell is an error, and if it is, delete that checkbox.
I was trying this code, but it doesn't work.
VBA Code:
If IsError(Cbx.LinkedCell) Then
Cbx.Delete
End If
Also tried this code, but this one gives me an error:
"Run-time error 438:
Object doesn't support this property or method"
VBA Code:
If IsError(Cbx.FormControl.LinkedCell) Then
Cbx.Delete
End If