Application.screenupdating = false (at the beggingin of your module)
this will get rid of the flashing, as Excel is trying to update your
GUI throughout the code. Try that first to see if there is noticable
improvement in perfomance time...
As a rule i avoid activate and select in all my excel v
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = "$B$3" Then MsgBox ("Call your Code here!!")
End Sub
set this in the worksheet object code in VBA
Tril
On Sep 11, 8:08 am, Tony Bender <[EMAIL PROTECTED]> wrote:
> Is there a way to set a cell so when the
