hi,
im using combobox to make a region search engine based on this tutorial : Create an Excel Drop Down Search
with some modifications i want to use down arrow to select item from the list but the problem is when i pressed down to list, combobox automaticaly value updated to the 1st suggestions.
sample :
>
how to make/select 2nd suggestions with arrow keys without updating combobox value ? so, combobox list wont change.
this is my code :
please help!
im using combobox to make a region search engine based on this tutorial : Create an Excel Drop Down Search
with some modifications i want to use down arrow to select item from the list but the problem is when i pressed down to list, combobox automaticaly value updated to the 1st suggestions.
sample :
how to make/select 2nd suggestions with arrow keys without updating combobox value ? so, combobox list wont change.
this is my code :
Code:
Private Sub Desa_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
Select Case KeyCode
Case 13
Dim rRng As Range, c As Range
Kec.Clear
Set rRng = ActiveSheet.Range("C32:C36")
If Cells(32, 2) <> "" Then
With rRng
For Each c In .Columns(1).Cells
If c.Value <> "" Then
Kec.AddItem c.Value
End If
Next c
End With
Else
Exit Sub
End If
Kec.Activate
Case Else
Desa.ListFillRange = "DropDownList"
Me.Desa.DropDown
End Select
End Sub
please help!