Hello everyone,I would like a macro that can update a summary sheet by clicking in different chekbox. What I mean is, I have 8 projects, and I only want 3 projects to appear on the main sheet by clicking in a chekbox for each project.When the checkbox is "checked", cells will be updated and when the checkbox is "unchecked", cell value will be cleared. The problem is there's no associated cell. They should "show up" in a specific place (B19-B27-B35).This is what I have at the moment, but it's not what I really wantThanks for your help!Sub Process_CheckBox() Dim cBox As CheckBox Dim LRow As Integer Dim LRange As String LName = Application.Caller Set cBox = ActiveSheet.CheckBoxes(LName) 'Find row that checkbox resides in LRow = cBox.TopLeftCell.Row LRange = "B" & CStr(LRow) 'Change date in column B, if checkbox is checked If cBox.Value > 0 Then Sheet2.Range(LRange).Value = Cells.Range("C13") 'Clear cells in column B, if checkbox is unchecked Else Sheet2.Range(LRange).Value = Null End If End Sub