VBA Userform drop down list appears blank

[Ge11i]

*I’m very new to VB, so I apologise in advance!
I’ve created my first userform for excel, want participants to enter their data, click ‘submit’ and excel will store the data on one of the sheets. Made drop down lists with a combo box, but when the user form opens automatically with the excel document, it the value appear blank? (see below) and is the same for all the boxes on the form.
[TABLE="align: left"]
<tbody>[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]

[/TD]
[/TR]
</tbody>[/TABLE]


This is the code I use for the drop down box:
Private Sub UserForm_Activate()
ComboContrib.AddItem 'Consent & Surgical Intervention', 0
ComboContrib.AddItem 'Consent & Patient Care', 1
ComboContrib.AddItem 'Patient Care & Data Aquisition', 2
ComboContrib.AddItem 'Other', 3
End Sub

Any ideas to why this is happening? Thank you.

 

[GTO]

If your code is as shown, you need double quote marks (rather than single) to indicate a string. A single quote mark (except if inside starting/ending double quote marks) indicates that the rest of the line is a comment and is ignored by the compiler.

Hope that helps,

Mark