View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default enter check mark with one click

Hi,

right click your sheet tab, view code and paste this in. It works for a1 -
A10 so change to suit

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not Intersect(Target, Range("A1:A10")) Is Nothing Then
If IsEmpty(Target) Then
With Target
.Font.Name = "marlett"
.Value = "a"
End With
Else
Target.Value = ""
End If
End If
End Sub

Mike

"touchngo" wrote:

What I want to do is be able to click on a cell and a check mark appears and
if I click again it disappears.
Is this possible?

Thanks