Results 1 to 4 of 4

Double Click to produce a strike-through AND a check mark

Threaded View

  1. #1
    Registered User
    Join Date
    05-26-2016
    Location
    louisville
    MS-Off Ver
    2013
    Posts
    2

    Double Click to produce a strike-through AND a check mark

    I am trying to find a code that can allow a double click (only in one specified column) to result in a check mark in that cell and a strike-through for the rest of the row.

    I found a template in excel that has this code but it does not copy over to other tabs when duplicated - even when i change the tab name in the code. What am i doing wrong? Here is the code:
    Option Explicit
    
    Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
    On Error Resume Next
     With Application
      .Cursor = xlNorthwestArrow
      BooleanCellDoubleClick Target, [tblToDoList[[Done]]], Cancel
      .Cursor = xlDefault
     End With
    End Sub
    Private Sub BooleanCellDoubleClick(rTarget As Range, rValidRange As Range, Cancel As Boolean)
    On Error Resume Next
     Application.CellDragAndDrop = False
        
     If rTarget.Cells.Count > 1 Then Exit Sub
     If Intersect(rTarget, rValidRange) Is Nothing Then Exit Sub
        
     If Len(rTarget) Then
      rTarget = vbNullString
     Else
      rTarget = 1
     End If
        
    Cancel = True
    End Sub
    Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer
    Last edited by 6StringJazzer; 05-26-2016 at 03:31 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Double click a cell to add check mark
    By Rocky2013 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-28-2015, 12:14 AM
  2. Double Click to insert Wingding - check mark
    By LeapingLizard in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-24-2015, 02:08 PM
  3. Always need to double click on the email to mark it as read
    By DURGESH88 in forum Outlook Formatting & Functions
    Replies: 2
    Last Post: 12-16-2014, 03:41 AM
  4. [SOLVED] Double-click macro to produce different results based on different cell ranges
    By Hobsons in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-06-2013, 07:28 AM
  5. Replies: 2
    Last Post: 11-13-2010, 05:06 AM
  6. Macro for inserting a check mark in several columns on right click
    By ElsiePOA in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-18-2007, 05:16 PM
  7. Replies: 3
    Last Post: 04-13-2005, 05:52 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1