Populating combobox with range

[Glove303]

I get an error if I try and populate a combobox with a range that only has one cell of data in it. If multiple cells have data it works fine.

Why is this?

Me.Tech_Com.List = Techniques.Range(Techniques.Cells(5, 1), _
Techniques.Cells(LastRowTech, 1)).Value

 

[Jerry Sullivan]

xl2007's Help article for List Property includes this note:

Use List to copy an entire two-dimensional array of values to a control. Use AddItem to load a one-dimensional array or to load an individual element.

So using .List for a single cell returns an error.

 

[Glove303]

That seems a bit poor that list can't handle one item. So the only solution is to have an if statement that checks if there is just one item, and if so uses additem, otherwise it uses list?

I'm glad I've discovered this, as I have lots of other code that is going to crash if my users delete entries and the column just has 1 entry!