Link checkboxes in different files

[Henk Rek]

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

 

[Glaswegian]

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

 

[Henk Rek]

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

 

[Glaswegian]

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