View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JimPNicholls JimPNicholls is offline
external usenet poster
 
Posts: 11
Default Setting ComboBox ControlSource in code

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?