User Forms Allow Tab Only to Move Between TextBoxes

[MarkA99]

Hi

Can someone help with this.
I have a customer that has a custom form to input/amend customer details and they want to only allow tabs to move between textboxes and comboboxes. At present if they use the arrow keys and enter a combobox they then change the option and they can't remember what they were originally. Is there a way to only allow tabs and stop the use of arrow keys when moving between form objects?

Thanks

 

[MarkA99]

I've found out how to solve this problem .

I've added the following code to each combobox:

Private Sub cboRef_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
If KeyCode = vbKeyUp Then KeyCode = vbNull
If KeyCode = vbKeyDown Then KeyCode = vbNull
If KeyCode = vbKeyLeft Then KeyCode = vbNull
If KeyCode = vbKeyRight Then KeyCode = vbNull
End Sub

Just in case any body has the same query.