Twollaston
Board Regular
- Joined
- May 24, 2019
- Messages
- 241
Good day all,
I am having an issue with my combo box. I have the combo box that is linked to a search box, and the search box output displays in the combo box so as I'm typing shows me all the entries that match may current input.
The issue is, when I tab out of the combo box and start inputting into the next cell, the combo box drop down menu opens up until I manually close it. I think it happens basically anytime the sheet is recalculated. I was wondering fi there is a way to only show the drop down when I'm typing, so that it doesn't pop open when i'm on other parts of the sheet.
The formulas in the range that populate my search output look as follows =IFERROR(INDEX('County ID Lookup'!$A$2:$A$3443,MATCH(ROWS('County ID Lookup'!$D$2:D2),'County ID Lookup'!$D$2:$D$3443,0)),"")
This is the code I have on the page:
(the bottom sub is so I can use the tab key to get out of the combo box)
If you have any suggestions to fix this I would really appreciate it.
I am having an issue with my combo box. I have the combo box that is linked to a search box, and the search box output displays in the combo box so as I'm typing shows me all the entries that match may current input.
The issue is, when I tab out of the combo box and start inputting into the next cell, the combo box drop down menu opens up until I manually close it. I think it happens basically anytime the sheet is recalculated. I was wondering fi there is a way to only show the drop down when I'm typing, so that it doesn't pop open when i'm on other parts of the sheet.
The formulas in the range that populate my search output look as follows =IFERROR(INDEX('County ID Lookup'!$A$2:$A$3443,MATCH(ROWS('County ID Lookup'!$D$2:D2),'County ID Lookup'!$D$2:$D$3443,0)),"")
This is the code I have on the page:
VBA Code:
Private Sub ComboBox1_Change()
ComboBox1.DropDown
End Sub
Private Sub ComboBox1_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
If KeyCode = 9 Then
Range("M6").Activate
End If
End Sub
(the bottom sub is so I can use the tab key to get out of the combo box)
If you have any suggestions to fix this I would really appreciate it.