Display text from same column inside static cell

[jokris]

See attached file.

When highlighting a cell beginning with row 9, I would like a text inside same column row 2 to be displayed inside another cell

Is it possible to achieve?

[Kaper]

Use event handler for selection change.
So in your Sheet1 code (not in standard module) write something similar to:

Please Login or Register  to view this content.

See attachment

[ImranBhatti]

Like this?

[jokris]

Perfect, thank you so much!

Use event handler for selection change.
So in your Sheet1 code (not in standard module) write something similar to:

Please Login or Register  to view this content.

See attachment