Rob

Thanks for your promt response. Works a treat!




-----Original Message-----
Excel 2k

Morning!

I've trying to set the control Source for a combobox (On
a
userform). I have:

Private Sub UserForm_Initialize()
Me.ComboBox1.ControlSource = Range("C1:C11").Value
End Sub

This isn't working (Type mismatch). Can anyone help?
.