+ Reply to Thread
Results 1 to 8 of 8

mutually link checkboxes

Hybrid View

  1. #1
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229

    Re: mutually link checkboxes

    I should have looked at the attachment. This looks like a good advertisement for Marlet check boxes.

    In the attached, I removed all the checkboxes (and all the formatting that hid the cell contents).
    On any sheet in the workbook, double click a cell in column A to select that player. The cell(s) on the other sheets for that player will be similarly affected. One can add new players without modifying the code, the only requirement is that the player's name be in column C of each of the sheets and that they be unique.

    This is all driven by this code in the ThisWorkbook code module.
    Private Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal Target As Range, Cancel As Boolean)
        Dim newVal As String
        Dim PlayerName As String
        Dim oneSheet As Worksheet
        With Target
            If .Column = 1 Then
                Cancel = True
                newVal = IIf(.Text = "X", vbNullString, "X")
                PlayerName = .EntireRow.Range("C1")
                On Error Resume Next
                For Each oneSheet In Me.Worksheets
                    oneSheet.Cells.Find(what:=PlayerName).EntireRow.Range("A1").Value = newVal
                Next oneSheet
                On Error GoTo 0
            End If
        End With
    End Sub
    Attached Files Attached Files
    _
    ...How to Cross-post politely...
    ..Wrap code by selecting the code and clicking the # or read this. Thank you.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] link active x checkboxes
    By MATT.B in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-23-2015, 04:53 PM
  2. How to Create checkboxes in Excel 2010 that link to Live Mail
    By smkei in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-27-2014, 12:15 PM
  3. CheckBoxes Cell link Copy & Paste problem
    By turist in forum Excel General
    Replies: 4
    Last Post: 02-23-2013, 12:39 PM
  4. Replies: 11
    Last Post: 02-14-2013, 06:39 PM
  5. Mutually-exclusive Checkboxes
    By DeBrent in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-12-2010, 08:03 AM
  6. [SOLVED] Making checkboxes mutually exclusive
    By instructorjml in forum Excel General
    Replies: 3
    Last Post: 04-06-2006, 01:50 AM
  7. [SOLVED] Link Checkboxes and Grey out the Check
    By Patrick in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-11-2005, 11:05 AM

Tags for this Thread

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