Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
When a cell is change
Good morning, How could I say to excel that when a cell changes (lets say a2)
execute something, something like: if cells(2,1)<"" then ...bla bla bla but this works just with cells with no values in them I want that wherever value is in the cell, when user changes it, execute the proceedure. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
When a cell is change
use a worksheet_change event.right click sheet tabview codeleft window use
worksheetright window change if target.address="$A$2" then bla -- Don Guillett SalesAid Software "filo666" wrote in message ... Good morning, How could I say to excel that when a cell changes (lets say a2) execute something, something like: if cells(2,1)<"" then ...bla bla bla but this works just with cells with no values in them I want that wherever value is in the cell, when user changes it, execute the proceedure. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
When a cell is change
Use the Change event if the user will cause the cell to change by editing
it. You would have to construct your code to operate the way you want. the event is triggered - then your code in the event determines when to act and when not to act. See Chip Pearson's page on Events http://www.cpearson.com/excel/events.htm -- Regards, Tom Ogilvy "filo666" wrote in message ... Good morning, How could I say to excel that when a cell changes (lets say a2) execute something, something like: if cells(2,1)<"" then ...bla bla bla but this works just with cells with no values in them I want that wherever value is in the cell, when user changes it, execute the proceedure. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
When a cell is change
Thanks you both, your information was very helpfull
(It's thanks you both or Thank you both???) "Tom Ogilvy" wrote: Use the Change event if the user will cause the cell to change by editing it. You would have to construct your code to operate the way you want. the event is triggered - then your code in the event determines when to act and when not to act. See Chip Pearson's page on Events http://www.cpearson.com/excel/events.htm -- Regards, Tom Ogilvy "filo666" wrote in message ... Good morning, How could I say to excel that when a cell changes (lets say a2) execute something, something like: if cells(2,1)<"" then ...bla bla bla but this works just with cells with no values in them I want that wherever value is in the cell, when user changes it, execute the proceedure. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change cell contents when pull down menu choices change | Excel Worksheet Functions | |||
making copied cells change with change in original cell | Excel Worksheet Functions | |||
excel deleting rows last cell does not change. How to change? | Excel Discussion (Misc queries) | |||
Change workbook sheet reference using cell A1 to change a vairable | Excel Worksheet Functions | |||
Change Cell from Validated List Not Firing Worksheet Change Event | Excel Programming |