Link checkboxes in different files

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Link checkboxes in different files

  1. #1
    New Member
    Join Date
    May 2004
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Link checkboxes in different files

     
    I have several managers working each on their own file. By checking a checkBox they can tell me the status of their project.
    I would like to have one spreadsheet in which I find checkboxes for each file (project). These checkboxes are linked to the checkboxes in the various project-files, showing me an overview of the status of all projects.
    Can anyone help me with this?
    I prefer the use of checkboxes, as I do not want any of this to be visible on my printout.
    Thanks for any help.

    Henk Rek

  2. #2
    Board Regular Glaswegian's Avatar
    Join Date
    Oct 2003
    Location
    Glasgow, Scotland
    Posts
    1,487
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Henk

    Welcome to the Board.

    If I've understood you properly, when a checkbox is checked on one wb then you want a checkbox to be checked on another wb?

    This will work - change the references etc to suit - based on a method provided by Aladin.

    Private Sub CheckBox1_Click()
    If [A5] = True Then Workbooks("Book1").Worksheets("sheet1").Range("B5").Value = True
    End Sub

    Where A5 is the cell containing the first checkbox. (No doubt there is a shorter way to do this).

    Does this help?

    Regards
    Iain - XL2010 on Win 7 Pro - A Bank is a place that will lend you money if you can prove you don't need it.

    Member of ASAP :: Member of UNITE

  3. #3
    New Member
    Join Date
    May 2004
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Link checkboxes in different files

    Thanx for the help. I had to replace cell names for checkbox names en finally worked it out like this:

    Private Sub CheckBox1_Click()
    If CheckBox1 = True Then
    Workbooks("Book1").Worksheets("Sheet1").CheckBox1.Value = True
    Else: Workbooks("Book1").Worksheets("Sheet1").CheckBox1.Value = False
    End If
    End Sub

    This works fine. I'm using the CheckBox from the ToolBox.
    I'm wondering: would it also be possible to use the CheckBoxes from the userforms?

    Henk

  4. #4
    Board Regular Glaswegian's Avatar
    Join Date
    Oct 2003
    Location
    Glasgow, Scotland
    Posts
    1,487
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Henk

    You could use the forms checkboxes - you would assign a macro to each checkbox. A control toolbox checkbox is an ActiveX Control and the code is stored within the control itself rather than assigned so that it runs when you click. You have more options and control over ActiveX Controls but I'm not sure if one is faster/more efficient than the other. Both methods work so use whichever suits your own purpose.

    Regards
    Iain - XL2010 on Win 7 Pro - A Bank is a place that will lend you money if you can prove you don't need it.

    Member of ASAP :: Member of UNITE

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com