Please read the forum rules and put the Code between ## so it will appear as follows:
Sub Process_CheckBox()
'This sub is assigned to all checkboxes on sheet1
'Cheched: Show Date
'Unchecked: Cell.Value = NULL (empty)
Dim cBox As CheckBox
Dim LRow As Integer
Dim LRange As String, RRange As String
LName = Application.Caller ' Multiple object are assigned to this Macro. Which is Calling this macro
Set cBox = ActiveSheet.CheckBoxes(LName) ' make pointer to this object
'Find row that checkbox resides in
LRow = cBox.TopLeftCell.Row 'In which Cell (and Row) is the TopLeft corner of the Checkbox
LRange = "A" & CStr(LRow) 'All in Column "B"
RRange = "B" & CStr(LRow) 'All in Column "B"
'Change date in column B, if checkbox is checked
If cBox.Value > 0 Then '0: UnChecked, 1: Checked
ActiveSheet.Range(RRange).Value = ActiveSheet.Range(LRange).Value
'Clear date in column B, if checkbox is unchecked
Else
ActiveSheet.Range(RRange).Value = Null
End If
End Sub
Bookmarks