| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatic detection of a change in a column/cell
Hi
I need to run some code to export a row from one worksheet to another when a cell has a date in it, also to remove the exported row when the cell is blanked, does anyone know a way of detecting when a cell has been changed ? Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Automatic detection of a change in a column/cell
Right click the sheet tab and select View Code. Then
paste the following to the worksheet code module: Private Sub Worksheet_Change(ByVal Target As Excel.Range) 'Your code here. End Sub Regards, Greg -----Original Message----- Hi I need to run some code to export a row from one worksheet to another when a cell has a date in it, also to remove the exported row when the cell is blanked, does anyone know a way of detecting when a cell has been changed ? Thanks . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatic cell color change when filled? | Excel Discussion (Misc queries) | |||
| How do I change the format/cell/border/automatic color to black | Excel Discussion (Misc queries) | |||
| Can I change a cell and cause an automatic change in other cells | Excel Worksheet Functions | |||
| Automatic change color of searched value in a column... | New Users to Excel | |||
| Color detection | Excel Worksheet Functions | |||
Linear Mode
