The following code was inserted on Sheet 1....Supposed to add a check mark in any empty cell in Col 5 or clear the cell if a check mark is already there when that cell is clicked.
It worked for a couple of months but no longer is working. Nothing has changed in the workbook that I can see...need some help here....
TIA Don
![]()
Private Sub WORKSHEET_BEFOREDOUBLECLICK(ByVal TARGET As Range, CANCEL As Boolean) Dim rge As Long rge = ActiveCell.Row ' MsgBox rge If Selection.Column = 5 Then If Selection = "" Then Selection.Font.Name = "Wingdings" Selection.Value = "ü" Else: Selection.ClearContents End If Else: End If Cells(rge + 1, 5).Select End Sub
Bookmarks