The keys' actions are bypassed by setting the Ke圜ode value to 0 and using an increment/decrement with the priorCmb.ListIndex value to change the selection. This can grab the arrow key presses and set a flag. The basic idea involves the priorCmb_KeyDown() event in the sheet where the combobox is located (though should be similar to KeyPress in overall behavior except using Ke圜ode instead of keyAscii, so adapt accordingly). I take it your ComboBox is called priorCmb, so I'm going to reference that for the events Seems like a bunch of us have had this issue! The answer is a stripped down version of what I use in a sheet for this same concept. I posted an answer here which seems to work for me. I was dealing with the same issue, and ended up finding some info on a Microsoft Help-site thread that let me play around with it. List = Split(Left(lstPrior, Len(lstPrior) - 2), "||") Else. If Len(itmPrior) > 1 Then If InStr(1, itmPrior, selPrior, 1) Then lstPrior = lstPrior & itmPrior & "||" If IsEmpty(cLstPrior) Then cLstPrior = (1) Public Sub filterComboListPrior(ByRef cmbPrior As ComboBox, ByRef dLstPrior As Variant)ĭim itmPrior As Variant, lstPrior As String, selPrior As String Private Sub priorCmb_GotFocus() 'or _MouseDown() Private Sub priorCmb_KeyPress(ByVal keyAscii As MSForms.ReturnInteger) = -1 'set ComboBox value to emptyįilterComboListPrior Tool.priorCmb, cLstPrior = cLstPrior 'initialize ComboBox to range Col A (UsedRange only)
Excel not scrolling with arrows code#
Here is the code for the combobox: Private Sub Worksheet_SelectionChangePrior(ByVal Target As Range)ĬLstPrior = Application.Transpose((1)) 'set module-level variable Please let me know if there's something I can do to avoid that behavior. However, when the user uses the down arrow key, the first item in the dropdown is selected and then is the only item remaining.Īlso, I would like to be able to use the scroll wheel if possible inside the dropdown list, and have the list sort such that when typing in am, items starting with a are displayed first. I would like the combobox to allow typing a character, and having the user be able to use the down and up arrows on the keyboard to scan through the list of items in the dropdown. I have an ActiveX control combobox in Excel that takes as filters a list of strings by characters typed in the box, where the user then selects the item he/she is searching for.
0 kommentar(er)
