Fire Event only when Cell Change?

  • Thread starter Thread starter HotRod
  • Start date Start date
H

HotRod

I had some code that I was working with the other day that would fire an
event only when the contents of the cell changed, any ideas? I'm currently
using the Worksheet_SelectionChange() but it fires every time I leave a cell
not only when the contents are changed.
 
How come these EVENTS aren't listed in the drop down lists?

By the way it was

Sub Worksheet_Change(ByVal Target As Range)

that I was thinking of.
 
They are listed in the drop down. Change the left drop down from
"(General)" to "Worksheet", and the worksheet events are listed
in the right side drop down.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
In the code when I fire the Worksheet_SelectionChange() Event I then
reformat the contents of a cell, this in turn re-fires the Event producing
an infinite loop. Is there something I can do, or do I need to create a
global variable to track this problem?
 
You need to learn how to program without selecting

Instead of

Range("A1").Select
Selection.Numberformat = "#,##0.00"

do

Range("A1").Numberformat = "#,##0.00"

no selection performed; no event triggered.
 
Back
Top