Search function

[Bippym]

Hi,

I have been trying to create a search routine, with little success. What I have are 22 different columns, I will only be searching one column at a time, and I would like to pass the number of the column to search to the sub as an argument along with the search string. ** Sub find(searchtxt, column)

I would then like to display certain columns from the row the results are in to a listbox from the userform it was executed from, and then allow the user to select the required result and that will then populate another userform (Using all information from the entire row).

I don't want someone to write this directly for me, I would like pointing in the right direction to achieve this myself.

Thanks

 

[GTO]

Hi there,

Given that you want to achieve this with only hints (which I applaud), could you show us what you have so far (code-wise)?

Off the top, I would suggest starting with putting the .Find in its own function. This way, you can pass the range (the column) being searched as an argument that should be able to pass back the cell found and have the function as a bool. That is just one way of course...