Worksheet_SelectionChange event not working [Solved]

Omi Kat - Nov 11, 2017 at 10:51 PM - Latest reply:  Omi Kat
- Nov 13, 2017 at 10:40 PM
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?


See more 

Your reply

2 replies

Zohaib R 2421 Posts Sunday September 23, 2012Registration dateModeratorStatus July 16, 2018 Last seen - Nov 12, 2017 at 10:21 AM
0
Thank you
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.
Thanks Zohaib! It worked like magic!

Regards,
Omi Kat
Respond to Zohaib R