Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF
How would I write a formula that if any of the cells in a certain row were
changed the 'A' coloum of that row would return a value of "updated"? Please and thank you |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF
You can't do that with a function.
You CAN do that with an event macro. Put this in your worksheet code module (right-click the worksheet tab and choose View Code): If you mean that an entry in ANY row should return updated to the column A cell in that row: Private Sub Worksheet_Change(ByVal Target As Excel.Range) With Target If .Cells.Count = 1 Then _ Cells(.Row, 1).Value = "updated" End With End Sub If you mean only a single "certain" row: Private Sub Worksheet_Change(ByVal Target As Excel.Range) With Target If Not Intersect(.Cells, Range("3:3")) Is Nothing Then _ Cells(.Row, 1).Value = "updated" End With End Sub if you mean a range of rows, you can adjust the Range in the second example, e.g.: If Not Intersect(.Cells, Range("3:9,12:13")) Is Nothing Then _ In article , Eán wrote: How would I write a formula that if any of the cells in a certain row were changed the 'A' coloum of that row would return a value of "updated"? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|