Report

Worksheet_SelectionChange event not working [Solved]

Ask a question Omi Kat - Last answered on Nov 13, 2017 at 10:40 PM by Omi Kat
Hello,

I wanted to execute a Worksheet_SelectionChange event code. But its not working. I searched on net to find that if I change (General) to Worksheet then it might work. But problem is in my module window the dropdown list is showing no other option than (General). What to do?


Helpful
+0
plus moins
Hi Omi Kat,

Let me try to help you. When you open the VBA Editor - on the left side you will see the Worksheets listed. You need to double click any one of the Worksheets (such as Sheet1) then you will see the Worksheet and SelectionChange dropdowns available. Otherwise you always see General under the dropdown.

Hope this helps. Please let us know.
Omi Kat- Nov 13, 2017 at 10:40 PM
Thanks Zohaib! It worked like magic!

Regards,
Omi Kat
Reply
Leave a comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!