Combobox1’s MatchEntry complete property quickly finds a matching value in the dropdown list and highlights the found selection in blue. So far so good.
But when I click the matched entry blue highlighted selection nothing happens.
What I WANT to have happen is what DOES happen when I press the ENTER key on the keyboard which immediately runs this code:
/code
Private Sub ComboBox1_KeyDown(ByVal _
KeyCode As MSForms.ReturnInteger, _
ByVal Shift As Integer)
Application.EnableEvents = True
Select Case KeyCode
Case 13 'Enter pressing enter on the keyboard runs the code between the select end select below:
ActiveCell.Offset(0, 5).value = "0.00"
ActiveCell.Offset(0, 1).value = _
WorksheetFunction.Index(Sheets("MYLIST").Range("MYRANGE"), _
ComboBox1.ListIndex + 1, 2) 'puts selected description value and corrsponding value category in Combobox1 on activecell row in A and B
Select case is = run this
Select case is = run this
End select
End select
/
But when I click the matched entry blue highlighted selection nothing happens.
What I WANT to have happen is what DOES happen when I press the ENTER key on the keyboard which immediately runs this code:
/code
Private Sub ComboBox1_KeyDown(ByVal _
KeyCode As MSForms.ReturnInteger, _
ByVal Shift As Integer)
Application.EnableEvents = True
Select Case KeyCode
Case 13 'Enter pressing enter on the keyboard runs the code between the select end select below:
ActiveCell.Offset(0, 5).value = "0.00"
ActiveCell.Offset(0, 1).value = _
WorksheetFunction.Index(Sheets("MYLIST").Range("MYRANGE"), _
ComboBox1.ListIndex + 1, 2) 'puts selected description value and corrsponding value category in Combobox1 on activecell row in A and B
Select case is = run this
Select case is = run this
End select
End select
/
Code:
Point: I want to get around having to press the ENTER key on the keyboard and immediately have the code between select and end select block run when the MatchEntry selection is clicked. How can I do this ?
(putting the code in the combobox Click event doesn't not work the way I am asking it to by just clicking the selected value)
Thanks for anyone’s help. Seems possible to achieve.
cr