I have several combobox lists that are filled with a redim array. When I use
redim array as the list the match entry complete does not work you have to
use the mouse to select from the list. If I use a simple array the match
entry works perfectly. I need to use redim because my list sizes vary on
other combo box selections. Any ideas on how I can correct the problem.
Below is my macro. I am using excel 2002

Sub add_itemcode_list(ByRef drp As ComboBox, pcode, lrow As String)
Dim i As Integer

For i = lrow To lrow + 25
If Sheets("Can05").Range("A" & i) < pcode Then
i = i - 1

Dim row As Single

ReDim myarray(lrow To i, 1)
For row = lrow To i
myarray(row, 0) = Sheets("Can05").Range("D" & row)
myarray(row, 1) = Sheets("Can05").Range("E" & row)
Next row
drp.List() = myarray
Exit Sub

End If
Next i

End Sub
--
Thanks!
Shane W