User Profile
Anggie
Copper Contributor
Joined 7 years ago
User Widgets
Recent Discussions
Re: VBA Drop Down List
Well the reason I added the keypress event was because I want the list to update while I type in the combo box. The problem with that is when I use the up and down arrow keys to scroll down the list it crashes and I would lose the initial codes I used. That is why I added the two keypress events.7.3KViews0likes4CommentsRe: VBA Drop Down List
Hi, can you explain how the dummy box works? I have typed in another code: Private Sub ComboBox1_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer) If KeyCode <> 40 And KeyCode <> 38 Then ComboBox1.ListFillRange = "DropDownListv1" Me.ComboBox1.DropDown Else KeyCode = 0 End If End Sub7.4KViews0likes6CommentsVBA Drop Down List
Hi Everyone, I developed a combo box drop down list and added a code that works fine but doesn’t let me scroll down my listed options using my down arrow keyboard button. Is there a code to use the down arrow and enter button on the drop down list. Here is the code I’m currently using: Private Sub ComboBox1_Change() ComboBox1.ListFillRange = "DropDownListv1" Me.ComboBox1.DropDown End Sub Hope anyone can help me!7.8KViews0likes15Comments
Recent Blog Articles
No content to show