Excel VBA - Using Combo Box Selection

I am trying to put some of my learning from the VBA course into action and struggling to call different routines based on the selection in a combo box.

The combo box is populated with the following options which works fine:

Private Sub UserForm_Initialize()
SelectReport.AddItem "********** Select a Report **********"
SelectReport.AddItem "Lost to Follow-Up"
SelectReport.AddItem "Intervention Type Missing"
SelectReport.AddItem "Intervention Setting Missing"
SelectReport.AddItem "Ethnicity Missing"
SelectReport.ListIndex = 0

End Sub


I then try to use this a bit later on when a button is clicked:

Sub ProduceReports()

If SelectReport = "Lost to Follow-Up" Then
Call LostToFUp
ElseIf SelectReport = "Intervention Type Missing" Then
Call InterventionTypeMissing
ElseIf SelectReport = "Intervention Setting Missing" Then
Call InterventionSettingMissing
ElseIf SelectReport = "Ethnicity Missing" Then
Call EthnicityMissing
Else: MsgBox "Please select a report from the drop down box before pressing the Run Report button"
End If

End Sub


I have tries using listIndex but cant get that to work either. I just ge the message box everytime. I have tried putting a msgbox before the IF to show SelectReport and get a blank so I am guessing the statement doesn't work as I haven't got anything stored as a variable for SelectReport but not sure how to resolve this.

Any help would be appreciated.