Combo box control (1 Viewer)

[GreenshootProgrammer]

I want the user to be able to use a combo box to select a value but I don't want them to be able to manually enter data, is this possible?

 

[missinglinq]

This code prevent the use, in a Combobox, of any keys except the Return, Tab, and Up and Down Arrow Keys:

Private Sub ComboBoxName_KeyDown(KeyCode As Integer, Shift As Integer)
 Select Case KeyCode
  Case vbKeyReturn, vbKeyTab, vbKeyUp, vbKeyDown
   KeyCode = KeyCode  'Accept these keys for Combobox usage
  Case Else
   KeyCode = 0   'Block all other keys
 End Select
End Sub

Just replace ComboBoxName with the actual name of your Combobox.

Linq ;0)>

 

[GreenshootProgrammer]

Works like a BOSS

 

[missinglinq]

Glad we could help!

Linq ;0)>