How to create a Web Hyperlink based on Cell Contents?

Hi all,

I've tried searching the forums for an answer, but had no luck. Will try my luck posting...and maybe it'll also help someone else as well:

-> In Excel Cell L4 to L9999, I would like to have Excel have that cell Hyperlinked of a Google search of the contents which were entered in that cell. (or, if that same cell can't be Hyperlinked, then a neighboring cell is OK)

-> So, for example, if cell L4 contained the word: "testing",
I would like to be able to click on that text in the cell to open a browser and take me to: "http://www.google.com/search?q=testing"

...I hope this can be done without writing a macro, (maybe by a formula instead?) BUT, if it's the only way of doing it, then yes, please, in that case, I would LOVE to know how to write/enter the macro.

Thanks SO much for your help!!
CG

Hi chatguy

You can try this code:

Please Login or Register  to view this content.

In sheet 2, enter the following:
B2 = google search
C2 = Test (or any word you wish)

Save the workbook, when sheet2 is activated, the above code runs.

Hope it helps you get started.

Closed for cross posting on two other forums. Please read forum rules below and PM me if you agree to then

VBA Noob