How to open the hyperlink automatically based on previous cell value (Any Value) on each cell

0

Dear experts,

I'm new , Could you please help me to fix this 

is it possible to open the hyperlink automatically based on previous cell value (Any Value) on each cell

Appreicate your support in advance

Answer
Discuss

Answers

0

A cell's value is static. Therefore it can't trigger any action. In Excel, only an action can trigger reaction. For example, the change of a cell's value can cause Excel to check if the new value meets conditions that could trigger a hyperlink to open.

To capture and harness an "event", as is its technical name, VBA is required. Besides the Change event Excel also has the Selection_Change (click) and Double-Click events plus a few more.

You can put these events to use by making a specific plan. For example, you can write code to follow the hyperlink in B10 when A1 is selected or when B11 has a certain value, or follow the link in B10 when A1 is clicked provided B11 has a certain value.

In fact the hyperlink itself uses the same technology. The hyperlink in B10 is followed when B10 is clicked, without any further check but with the condition that the click isof short duration.

Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login