I should know this, but... How to run macro when cell is activated
Posted by Pasi Vartiainen on November 06, 2000 3:04 AM
This questin is maybe asked multiple times, but I am unable to find it from here. I have tried seach, but nothing occurres.
I want macro to run every time when cell is activated. So when user points cell with mouse, or shifts cell with arrow or uses page up/down key, macro is runned.
Macro which I want run is ready, but I dont know how to run it when cell is activated
parametri = ActiveCell.Value
For i = 1 To 300
If Cells(i, 1).Value = parametri Then
Cells(i, 2).Value = parametri
i = 299
Shapes("TextBox1").Value = parametri
Hope that some-one can help me.