Need Excel/Visual Basic Help

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?

Why would they suggest Excel for this, clearly they should be using Acess for this sort of lookup.

Quote:

---

Originally Posted by Adam

Why would they suggest Excel for this, clearly they should be using Acess for this sort of lookup.

---

I honestly don't know why, but it is what we have to use, and i really don't know how best to turn a product list into a database, and then create a search function, and then link the two together.

Unless there is an alternative.

you will have to use vlookup I think unless there is another way to do it.

it may be helpful if you post some mockup screenshots from Excel
with a description of what you want

Code:

---

                        _______
Search for: Single      |Search|
                        """""""

Room size                1/2 board              Full board
Single                        30                      50
Double                        50                      70
Double balcony                70                      90

---

I input "Single" into box, press search, and a message box pops up with 1/2 & full board prices

or, something

Okay Ynot,

I'll load it up and get some screenshots and show you what i mean, it could take a while but if it means i can get some sense of direction with this then thats awesome. I honestly am no good with computers :P

I'll have it up in an hour.