Searching Online For Item entered in worksheet text box

[ebogenschuetz]

Hello, I have been working on this for quite some time now with no luck and have done plenty of searching with no exact information on how to do this.

A little background info:

I have a spreadsheet setup with a lot of different products, these products are stored on a tab named "shower doors". I then have setup with macros a "searching criteria" tab where you can perform different search's and after your criteria is slected you press "find products" and it moves you to the thrid tab named "results". This tab then displayes the resuts (if there are any) for the criteria you selected.

Now the part I am stuck on. I want to be able to have a search box, where the user can enter part of a model number, and then press a search now button, where it would take the model number and go out to our web page and do a search. I already have it where you can click the search now button, and it will bring up our web page, however I cannot figure out how to get the search text box to copy the text the user enters and past it into the URL so it guides the serach to the specifc page instead of just our main page.

For example if I wanted to have the text from the text box selected, copeid, and pasted into the end of a URL

user enters= 1500D
presses search now
Macro copies 1500D, and pastes it into the url such as www.Companyname.com/productpage=1500D


Any help would be greatly apperciated. This is driving me nuts trying to figure it out.

Thanks everyone.

 

[shg]

Why not just use a function?

If A1 contains the product ID, then in B1,

=hyperlink("www.Companyname.com/productpage=" & A1)