Visual Basic Check Boxes

[emily2309]

I will explain my spreadsheet first to let you know what I am doing.

I am creating a scheduling program for my company. I want the spreadsheet to feedback to me what shifts are available for overtime depending on who is on holiday. I have set it up to show everyones shifts when they are not on holiday. Everyone's shift has an IF statement, which is linked to another sheet. This IF statement basically says that if the colleague is on holiday, do not put their shift here. This means it will be left blank and i will know that they are on holiday.

Right..
I have created a user form, where i will enter who is on holiday. I have a combo box to select the colleague, and then below that i have check boxes to select which days they are on holiday. What i need help with is how to code the check boxes so that when they are clicked, they send data to the spreadsheet to say which one is clicked. It also needs to link to the colleagues name.
Basically, I am going to need to paste into the spreadsheet "on holiday" for each colleague and each day they are on holiday.

I hope this makes sense!

Thanks

 

[doofusboy]

Maybe something like this?

Private Sub CheckBox1_Click()
    If CheckBox1.Value = True Then
        Select Case ComboBox1.SelText
            Case "Joe"
                Range("A1").Value = "On Holiday"
            Case "Moe"
                Range("A2").Value = "On Holiday"
            Case "Mary"
                Range("A3").Value = "On Holiday"
            Case Else
                ' no name selected
                Exit Sub
        End Select
    End If
End Sub

 

[emily2309]

BRILLIANT! Thanks
Now just the long effort of writing all the coding from yours..
Thanks a lot