Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Fire Event only when Cell Change?
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Fire Event only when Cell Change?
Hi
use Worksheet_Change check out http://www.cpearson.com/excel/events.htm for more info -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "HotRod" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Fire Event only when Cell Change?
Don't use the SelectionChange event. Use the Change event.
-- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "HotRod" wrote in message ... 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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Fire Event only when Cell Change?
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. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Fire Event only when Cell Change?
They are listed in the dropdowns for the class modules where they are
defined. -- Regards, Tom Ogilvy "HotRod" wrote in message ... 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. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Fire Event only when Cell Change?
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 "HotRod" wrote in message ... 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. |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Fire Event only when Cell Change?
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? |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Fire Event only when Cell Change?
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. -- Regards. Tom Ogilvy "HotRod" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Fire Macro from Cell Change | Excel Worksheet Functions | |||
Event doesn't fire | Excel Discussion (Misc queries) | |||
Workbook Open Event does not fire | Excel Programming | |||
Event class doesn't fire in embedded VBA | Excel Programming | |||
How do I get Pivot filter change event to fire? | Excel Programming |