Hi all!

Having a big problem with my lack of coding skills so here is what I am trying to do. I have a User-form where I have a cboBox that lists all the existing active owners. Once an owner is chosen their information from the owner log should populate the User-form so any changes in their existing data can be made and saved. I have attempted a weak effort that follows:

Private Sub cboFindOwnerOIAU_Click()

Dim ws As Worksheet
Dim rng As Range

Set ws = ThisWorkbook.Sheets("OwnerLog")
Set rng = Range("rngOwnerLog").Find(What:=cboFindOwnerOIAU.Value, lookAt:=xlWhole, LookIn:=xlValues)
                                    If rng Is Nothing Then
           MsgBox "Last name not found"
     Else
      txtOwnerIdOIAU.Value = Range("A5").Value
                                                    
      End If
End Sub
It does not work and I have searched over the last few days but can't find anything to get me over the hump.

Here is the file:

ES Program Test v4.xlsm

Thanks in advance for any help to get me moving in the right direction!

u3rick