Userform Search

Hi Friends,
This is my first post in this forum.

I have a file which uses an userform to input data.

I can also search for entries using the user form.

I have attached the file for your reference.

But the search is restricted to only one field (Display name).

Is it possible to search using different fields (one at a time).

Is it possible ????

Regards,

Salim.

You could do this by adding a DropDownListBox with your colum headers

In the cmbFind_Click event you would change the column for rSearch based on the selected value in the listBox.