Hey Guys,

I'm currently working on my ICT coursework and the task is to create a spreadsheet in Excel which is like a booking form with an invoice and order form etc. We have to link everything together using macros which i have done, however it is the coding and formulas which trouble me.

I might as well start off by saying this, what i am looking to achieve is a keyword search function. I have a database of about 30 products, and i need to create a search function which allows the product to be searched for by the use of keywords.

My teacher says that this is going to be hard, but i don't know how i would go about doing it, especially in visual basic.

So basically, i am looking to link my list of products as a database so that i can then link it to a keyword search function in which you can type in and search the database via keywords.

Can anyone help me, i know its hard but i'd really appreciate any help i can get?