Advertisement
Guest User

Untitled

a guest
Oct 31st, 2014
126
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.40 KB | None | 0 0
  1. Private Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal Target As Range, Cancel As Boolean)
  2. If Not Intersect(Target, Range("A1:A19")) Is Nothing Then
  3. If Len(Trim(Target)) = 0 Then
  4. Target.Value = "X"
  5. Cancel = True
  6. ElseIf UCase(Trim(Target)) = "X" Then
  7. Target.ClearContents
  8. Cancel = True
  9. End If
  10. End If
  11. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement