Change cell text based on text (from drop-down) in another cell

Hey all,

I'd probably figure this out myself, but am on a deadline and need to do it fast. Like in the title, I'm trying to have a certain range have a certain text based on what user inputs in another cell. I thought this code would do the trick:

Please Login or Register  to view this content.

But it gives a type mismatch. I'm guessing it's because I'm using .Value instead of .Text for string?

(*Tried using .Text, but didn't help).

Thanks for any hints.

Well, I dug a bit more, since noone was able to help and found a workaround solution. In case anyone is interested, I post it here:

1. The code that goes in the particular Sheet:

Please Login or Register  to view this content.

- this one calls a sub "technical" whenever cell H9 changes its value.

2. Then the sub "technical" checks what value does H9 contain and based on that, it performs certain tasks:

Please Login or Register  to view this content.

Not the perfect way to do it, I'm sure, but one that works.