Search Function in a User Form

[jason_kelly]

Hello,

I would like seek your help in creating a user form search function.

in the database are 3 fields

Received Date | File Number | Assigned To


For example, let's say if I wanted to search the received date, the search results would then populate my form with the values for that row.

I would also like the same search functionality for the other 2 fields (File Number and Assigned To) as well, so if I searched by file number/Assigned to, it would populate my form with the Received date, File number and Assigned to values.

You're help with this is greatly appreciated.

Much thanks and appreciation.

Cheers,

Jason

 

[AlphaFrog]

Excel sort of already has a feature like this called DataForm

Sub Macro1()
    Cells.Find(What:="Received Date").Select
    ActiveSheet.ShowDataForm
End Sub

 

[jason_kelly]

Hello,

Thanks for the advice,

However, I am more looking to customize my search feature rather than use excel's default standard.

Any help with getting this code started is greatly appreciated.

Thanks a bunch.

Jason