Combobox auto complete

[Yogi]

I have a worksheet named, "Database2". There are hundreds of names in colum B starting in row 3 of this worksheet.
In the same Workbook is a worksheet named, "Records". I want to create a userform with a combo box, an "Enter" and "Cancel" command button. When typing begins in the combo box I need it to recognize the name from the "Database2" list in colum B and executes auto complete. When the "Enter" button is clicked I need it to enter the name in the first available row in colum B starting in row 3 in the Worksheet named "Records".
Any help is greatly apreciated.
Thanks

 

[bobm]

Jaafar

Exactly!
The reason I specified that property is because I figured Yogi would not want a name entered if it was not on the list.
I guess you just never know.

Bob

 

[Yogi]

Perfect, thanks!

 

[Orbix]

Just want to make a follow up question on this thread. What if I choose not to use a user form. Instead I just want the "Enter" and "Cancel" button in my sheet and not in a form. And so the following line would not be applicable anymore, especially the

Private Sub UserForm_Initialize()
...
End Sub

Private Sub UserForm_Initialize()
  With cboNames
    .Style = fmStyleDropDownList
    .MatchEntry = fmMatchEntryComplete
    .EnterFieldBehavior = fmEnterFieldBehaviorSelectAll
    .RowSource = "Database2!Names"
    .ListIndex = 0
  End With
End Sub

Basically I just need to make the combo box, Enter and Cancel button appears in the my sheet and not in a form and still performs the same functions of auto-complete. Any suggestions?