How to prevent users from typing values in combo box (1 Viewer)

[tkatende]

Hello there,
I need some help on how to prevent users from typing values into the combo box other than those listed by the combo box drop down menu.[I would like to have this done for purposes of consistence in the data]
Thanks
Timothy

 

[John Big Booty]

Set the combo box's Limit To List property to Yes

 

[missinglinq]

Another approach would be to simply not let them enter anything into the combobox, rather than throwing up a flag after they've done so, as Limit to List will do:

Private Sub ComboBoxName_KeyDown(KeyCode As Integer, Shift As Integer)
 If KeyCode <> vbKeyTab And KeyCode <> vbKeyReturn Then KeyCode = 0
End Sub

Or warn the user as soon as they attempt to enter new data:

Private Sub ComboBoxName_KeyDown(KeyCode As Integer, Shift As Integer)
 Select Case KeyCode
 Case vbKeyTab, vbKeyReturn, vbKeyDown, vbKeyUp
  'Do nothing
 Case Else
  KeyCode = 0
  MsgBox "You must select a value from the dropdown!" & vbNewLine & vbNewLine & "       You cannot enter new data here!"
 End Select
End Sub

 

[Dhalsim]

Hello

Is there a way to modify this bit of code to allow alphabet keystrokes to jump down the combox list. e.g hit "J" and go to first J in list.

Private Sub ComboBoxName_KeyDown(KeyCode As Integer, Shift As Integer)
If KeyCode <> vbKeyTab And KeyCode <> vbKeyReturn Then KeyCode = 0
End Sub

Cheers

 

[missinglinq]

Maybe I'm misreading your post, but if you're talking about hitting a given letter and having it scroll down to the first entry starting with that letter, not really. That's the default behavior (with Auto Expand set to Yes) but users cam either type into the Control, or using the above code, cannot type into the Control.

Linq ;0)>

 

[Dhalsim]

yeah that's what I meant. Thanks for the reply.