Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
matched entry complete not working
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Complete not working in one column | Excel Discussion (Misc queries) | |||
auto complete not working | Excel Discussion (Misc queries) | |||
automatically add borders to a cell after entry is complete | Excel Discussion (Misc queries) | |||
Auto-complete an entry in drop-down list | New Users to Excel | |||
Not unhiding rows when pointing to cell to complete formula entry | Excel Programming |