Thread: Leftclick = "x"
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Carim Carim is offline
external usenet poster
 
Posts: 510
Default Leftclick = "x"

Hi,

May be with double click ...

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, _
Cancel As Boolean)
With Target
If .Cells.Count 1 Then Exit Sub
If Intersect(.Cells, Me.Range("B:B,D:D")) Is Nothing Then Exit
Sub
If .Value = "" Then
.Value = "X"
Else
.Value = ""
End If
End With
End Sub


HTH
Cheers
Carim