Debug error

[stuntmannen]

Hi!

I have a worksheet with a list of codes that I need to decode
I use the following code today in my worksheet:

Please Login or Register  to view this content.

Then I use this code in cell B3 to decode the value in B2:

Please Login or Register  to view this content.

But since I suck when it comes to programming I tried the following:

Please Login or Register  to view this content.

...but got a debug error.

Can someone see what I'm trying to do?
I only want B2 to display something if I click in the range C20:C51

What am I doing wrong?

[romperstomper]

Please use code tags around your code, or we can't answer you. (it's a fairly simple fix BTW).
[code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code]

[sweep]

Try this - it should get you started in the right direction.

In future, please post your code between tags, as in the forum rules.

Please Login or Register  to view this content.

[stuntmannen]

Sorry for the code mishap. Apparently it's not only coding I suck at.

Thanks alot it worked perfectly. But the only small thing now is that if I click
outside the range, the old information from when I clicked within range A2 is still
there. I want A2 to be blank unless I click in the range.

[romperstomper]

You need to clear it explicitly:

Please Login or Register  to view this content.

[stuntmannen]

That worked perfectly!

Thank you very much!