'When hyperlink in specific cell clicked, then record that cell address as a last action log

im very new in VBA, and i gonna appreciate who ever wanting to help me... Here i have a case, i have several conversation action that linked with Hyperlink. lets say conversation module placed in cell Q6-Z6, and every cell has a title as a code (p1-p9) which placed on cel Q5-Z5.. i want to make, if that hyperlink clicked (Q6-Z6), then will print title code as a last action log(p1-p9) in targeted cell.

Here i attach a picture that explain what i want..

Thanks for helping

Picture Explanation



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source