Gents
I'm using the following to check for a valid entry in combobox1 and throw out an error message if not true.
Can anyone spot why my focus is not returning to the combobox on acknowledging the message box. The cursor simply sits on whatever control I selected to exit the combobox
Code
Private Sub combobox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)
If ComboBox1 = vbNullString Then Exit Sub
If ComboBox1.ListIndex = -1 Then
MsgBox "Enter A Valid Job Number"
Me.ComboBox1.Value = ""
Me.ComboBox1.SetFocus
End If
End Sub
Display More
Any suggestions appreciated