How does worksheet selectionchange work

Your guidance is highly appreciated. This is great dangelor , thank you a ton for this update as this works. Look forward to interact with you and learn from you! I am trying to improve the runtime of this event based macro, as the performance is slow and it takes a few second on each cell click to be able to enter the values.

Your expert advice and any suggestion will be highly appreciated to enhance the speed of this macro! One thing that might help is using the Worksheet Change event instead of the Worksheet Selection event, but the hiding and unhiding is your problem.

Why are you using code to add formulas and adding values to D20 to D23? These could be entered manually - I don't see anywhere in the code that removes them. Namaste royUK ,. I have another Macros assigned on a Module, allocated to a button which brings everything to default blank cells. Currently it takes about secs on each cell when clicked before it would allow to enter a value.

Don't quite understand why there would be a problem with the change event. I think Roy's suggestion of posting a sample workbook would help in solving your problem. Thank you royUK and dangelor for your revert and effort. I have attached a sample file herewith. This sample file works a little faster then the actual file. I wanted to take a moment to thank you for all your help and efforts here, and I know how time consuming it could be, specially for a novice like me, this is all a big deal, and I am learning so much in this process from you.

I tried this in my actual file, and seems to be working fine and faster then the previous version I attached. There are a couple of places which are not responding, which I am working on, and will update you soon. Sadly, when I create an addin I can use modules, I do not know how to put the code into active workbook. If you want an application-level functionality then you need "application events" - see docs.

Tim, thank you for your help. The guide from microsoft helped me with setting the application-level event handler. It does precisely what I wanted, thank you very much! Add a comment. Active Oldest Votes. Just to give a start.

This may not answer this question completely. Worksheets ws. Improve this answer. Naresh Naresh 2, 2 2 gold badges 7 7 silver badges 15 15 bronze badges. You can use a Public Boolean variable? How are you setting the option to Active?

In the same way you can set the Boolean Variable to true or false. And give condition to run the macro only when it is true. Answer edited. See the toggle macro and condition in the workbook You can toggle with a button and make the test macro active or inactive.

Thanks Naresh for your help. Your solutions helps me technically thanks for that but it does not help me with "application-level events". In this example, we compare the Target with the given cell range A1:A10 using Intersect method:. The following code highlights the active cell with a red color every time a different cell is selected:. The first statement removes the background color for all cells in the worksheet. Next, the the active cell is shaded with red color.