Please wrap your code in code tags, before the moderators get you...

Forum rules
3. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # button at the top of the post window. If you are editing an existing post, press Go Advanced to see the # button.

You need to use the Worksheet SelectionChange event

An example of what you are trying to do would not go amiss.

Cheers.