Code to insert check mark
Sorry, here is the code.
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
If Target.Count 1 Then Exit Sub
If Target.Column = 1 Then
If Len(Trim(Target.Value)) = 0 Then
Target.Value = Chr(252)
Target.Font.Name = "Wingdings"
Target.Font.Size = 10
Else
Target.ClearContents
End If
End If
End Sub
"jmcclain" wrote:
I found the following code in a post from 2005. I tried to follow the
instructions. I pasted the code in the view code and exited back to EXCEL.
i am trying to allow a user to click column D, E, and F and have EXCEL
automatically insert a check mark.
Am I on the right track? Can someone outline the process to "activate" this
code so it will work?
Thanks again
Jon
|