Load ComboBox from Range

[Ardito]

Good afternoon all,

First time here and requiring some help.

I was using this code successfully since the beginning of my coding. Today I added a substantial amount of code to the UserForm and now I receive error message on my initial ComboBox load.

Private Sub Worksheet_Activate()
ComboBox1.List = Sheets(Codes).Range("A1:A116").Value
End Sub

If I run UserForm I have no errors and the program runs fine. However if I run Debug I receive Subscript Out Of Range.

Thanks in advance.

 

[jproffer]

Have you tried to use the RowSource property instead of List?

Nevermind, you're talking about an activeX CB, not a userform CB...



MOD - please delete this post so the OP still shows on the zero replies list.