Userform Problem

Hi Forum,

I have a problem with my userform, and a combobox on it as follows:
Private Sub CommandButton1_Click()
UserForm1.Show (0) 'Modal 0
End Sub

The combobox properties:
1-fmMatchEntryComplete
1-fmEnterFieldBehaviorRecallSelection

THE PROBLEM IS:
When i typing some letter in the combobox field, the userform become unfocused after 2 or three letters, the focus change into the excel sheet. So i cannot complete the word in the combobox.

Sorry i forgot to mention in the above, i still need the userform to be MODELESS, because i don't want to close the form to be able to access the excel sheet.

I think, but not sure..., that you have to give more details on the way you load the combobox. Are you using RowSource property or AddItem method to fill this combobox ?

Also, you should use the constants vbModal or vbModeless instead of 0 or 1 which don't give much explanation when reading the code.