Search through database and display results in userform

Hello karthikcoep,

I have made the changes to the attached workbook to search only the worksheet pointed to by Sheets(1).

Sincerely,
Leith Ross

Hello Leith,
The file u sent is running fine,
but when i export the userform and import it back to use in my file it is not working. The gridlines are not visible.There is not error but in the listview control only the row no is displayed and nothing else.
Please help.
I tried this on a blank workbook then also it is not working.

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

Hello Leith Ross, I found the program you wrote absolutly useful to a project that I am working on right now that has over 2500 product. I am wondering though, is there a way to change the code slighly to select the condensed data in the user box, and have it return to the worksheet highlighted. The only reason I would as Is that I would use a similar program so that the user could get to that row to access pdf forms that are embeded in each row? Any ensight would be lovely.

we have 300 employee's details in sheet 1 (passport details / visa details/ labour details/ personal details/ salary details/ leave details) in sheet 2 need user form if i enter emp id then i have to get all details of emp. in sheet 2