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
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
How to open the hyperlink automatically based on previous cell value (Any Value) on each cell
0
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.