I've created a UserForm that has a ComboBox (w/RowSource = a Range) from which you can select a Department. The UserForm also contains a list of 20 Labels, each with a TextBox next to it. These are tasks for which to enter hours (in the TextBox). See my example below. This is working fine. My challenge is this: Sheet 8 has 15 columns ("A" through "O") for different departments, each column has up to 20 items (tasks) listed below the columns header which contains the department names.
How do I add an IF statement so when I select a different department (which is in Sheet8 column B for instance) from the ComboBox, the Sheet8.Range("A3").TEXT will change to Sheet8.Range("B3").Text

Private Sub UserForm_Activate()
txtStartDate.Value = Format(Date, "mm / d / yy")
Label1.Caption = Sheet8.Range("A3").Text
Label2.Caption = Sheet8.Range("A4").Text
Label3.Caption = Sheet8.Range("A5").Text
Label4.Caption = Sheet8.Range("A6").Text
Label5.Caption = Sheet8.Range("A7").Text
End Sub

There are 20 labels, but I'm only showing the first few as an example. As you can tell, I'm a beginner at VBA, and any help will be greatly appreciated. Thank you!
John