Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Daniel
 
Posts: n/a
Default in vba what command is used to determine if a particular cell on a particular sheet changed? some kind of event? how to get the old and new value of the cell?

in vba what command is used to determine if a particular cell on a
particular sheet changed? some kind of event? how to get the old and new
value of the cell?


  #2   Report Post  
Chip Pearson
 
Posts: n/a
Default

The Worksheet_Change event procedure is executed whenever a cell
is change.




"Daniel" wrote in message
...
in vba what command is used to determine if a particular cell
on a
particular sheet changed? some kind of event? how to get the
old and new
value of the cell?




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Transpose unique values in one column/mult. rows into a single row Wil Excel Worksheet Functions 1 May 22nd 05 08:52 AM
Modification of Part Number (Revised) Tiziano Excel Discussion (Misc queries) 4 February 27th 05 01:37 AM
Part Number/Qty Consolidations [email protected] Excel Discussion (Misc queries) 2 February 6th 05 10:21 PM
formula to determine the first column containing any data sd Excel Worksheet Functions 5 November 9th 04 09:06 PM
Formula for Extracting Alphabetic Part of a Product Code ob3ron02 Excel Worksheet Functions 5 October 30th 04 12:35 PM


All times are GMT +1. The time now is 06:49 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"