Worksheet_SelectionChange event not working [Solved/Closed]

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


Related:

1 reply

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