Worksheet_SelectionChange event not working [Solved/Closed]

- - 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 

1 reply

Posts
2403
Registration date
Sunday September 23, 2012
Status
Moderator
Last seen
December 13, 2018
649
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