Previous Topic Next Topic

Worksheet_SelectionChange event not working

Solved/Closed
Omi Kat - Nov 11, 2017 at 10:51 PM
 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?


1 response

Answer 1 / 1
Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 69
Nov 12, 2017 at 10:21 AM
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.
0
Omi Kat
Nov 13, 2017 at 10:40 PM
Thanks Zohaib! It worked like magic!

Regards,
Omi Kat
0