Extracting specific data from a worksheet

[njd976]

Hi guys,

I'm pretty new to VB but hopefully you can help!

I'm trying to make a form that has a search function (textbox and button), which will take the text in the textbox and search through an excel spreadsheet column to find the specified text...

I then want the found text row data (there are 5 columns) to be displayed on the form.

I hope that shoddy description kind of makes sense! what do you think the best way to do this would be?

Thanks,
Nick

 

[Trevor G]

Welcome to the Forum.

You would need some kind of Unique Number and then you can search based on that, if you use something like a Names you have the possiblity to find a number of the same names.

Which version of Excel are you using as 2003 has a Form you could use.

 

[njd976]

Hi Trevor,

Thank you for your reply...

I have used the application.match function, which seems to be working quite nicely with the added benefit of some if statements to combat any errors.

I will let you know if I start to struggle again.

Cheers