Search through database and display results in userform

Hello karthikcoep,

The problem is the reference library isn't loaded on the other machines. The workbook I posted has the reference saved. I have added a macro that will automatically load the library reference when the workbook is opened. Here is the auto loading macro which is called by the Workbook_Open() event procedure. This macro is located in Module1.

Sub AddListViewControl()

  Dim P As Variant
  Dim Paths As Variant
  Dim RefFile As String
  Dim X As String
  
    RefFile = "MSCOMCTL.OCX"
    
    Paths = Split(Environ("Path"), ";")
      For Each P In Paths
        X = Dir(P & "\" & RefFile)
        If X = RefFile Then Exit For
      Next P
  
      If X = "" Then
         MsgBox "The directory for " & RefFile & " could not be found."
         Exit Sub
      Else
         RefFile = P & "\" & RefFile
      End If
      
    On Error Resume Next
      Application.VBE.ActiveVBProject.References.AddFromFIle RefFile
      If Err = 0 Or Err = 32813 Then Err.Clear
    On Error GoTo 0
  
End Sub

Workbook Open Event - ThisWorkbook Module

Private Sub Workbook_Open()
  Call AddListViewControl
End Sub

Sincerely,
Leith Ross

Thanks a lot Leith.
May god bless u!!!!!!!!!!!!!

Leith,
you've come sooo close to solving an project that has stumped me for weeks!
in my woorksheet (see attached) i'm trying to search list (M) and chose from search list to return to cell D5. "D5:D55" will have this ability. Can you take me this last step?
thank you,
sick