View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
PJ Murph[_2_] PJ Murph[_2_] is offline
external usenet poster
 
Posts: 19
Default Click a cell next to an item and have a checkmark appear

You are 'The Man'! Thanks, Marcus, have a Happy New Year.

"marcus" wrote:

Hi JP

This should sort you out. Highlight the column you plan to click on
and format that column as Wingdings. Paste this code in the worksheet
module where you want the event to occur, so Sheet1 for example.

I have made it a doubleclick event so it will appear and disappear as
you DOUBLE click on the cell.

Take care

Marcus



Option Explicit

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel
As Boolean)
On Error Resume Next
If Intersect(Target, Range("F2:F6")).Value = "ü" Then
Target.Value = ""
Else: Target.Value = "ü"
End If

End Sub
.