Macro to display Google search hyperlinks and tooltips reading other cell value from same record

rodion

New Member
Joined
Feb 27, 2019
Messages
1
Hello, newbie here.

I wonder if it's possible to create a macro which creates hyperlinks for all existing values in a column such that:
1. When user clicks a cell link, a Google search result page opens, showing results based on existing cell string value
2. Tooltip of each hyperlink shows value of another cell in the same record (this is needed because the respective column is hidden)

For example,
1. Clicking John displays a Google search for string "John"
2. Tooltip for hyperplink John is

Visible column
Hidden column
Johnstring B
Lucystring C

<tbody>
</tbody>

I need to use a macro instruction that is true for any record (i.e. not a separate instruction for each record or string value).
I am not a programmer and am not familiar with Excel syntax, I am hoping to be able to (more or less) paste code in the VB editor and do minor adaptations :)

Many thanks for looking into this!
Rodion.
 

Some videos you may like

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

Watch MrExcel Video

Forum statistics

Threads
1,128,122
Messages
5,628,806
Members
416,342
Latest member
BlueDevil12

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top