| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
indicate a change in a row
I would like to indicate with a specific value ("C") in the first cell of a
row if any changes have been made in that row since the file was created. In other words if a value was input or changed in cell "M1" i would like cell "A1" to be populated with a "C". Can this be done? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
indicate a change in a row
Put the following macro in the worksheet code area:
Private Sub Worksheet_Change(ByVal Target As Range) Application.EnableEvents = False Cells(Target.Row, 1).Value = "C" Application.EnableEvents = True End Sub -- Gary''s Student - gsnu200738 "Picman" wrote: I would like to indicate with a specific value ("C") in the first cell of a row if any changes have been made in that row since the file was created. In other words if a value was input or changed in cell "M1" i would like cell "A1" to be populated with a "C". Can this be done? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
indicate a change in a row
Could you walk me through the "worksheet code area". I'm not familier with
this part of Excel. Also how can i change the coordinates of the destination cell to allow for column headings etc? "Gary''s Student" wrote: Put the following macro in the worksheet code area: Private Sub Worksheet_Change(ByVal Target As Range) Application.EnableEvents = False Cells(Target.Row, 1).Value = "C" Application.EnableEvents = True End Sub -- Gary''s Student - gsnu200738 "Picman" wrote: I would like to indicate with a specific value ("C") in the first cell of a row if any changes have been made in that row since the file was created. In other words if a value was input or changed in cell "M1" i would like cell "A1" to be populated with a "C". Can this be done? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
indicate a change in a row
Right click on the worksheet tab that should have this behavior and select view
code. Then paste this into the newly opened codewindow. Picman wrote: Could you walk me through the "worksheet code area". I'm not familier with this part of Excel. Also how can i change the coordinates of the destination cell to allow for column headings etc? "Gary''s Student" wrote: Put the following macro in the worksheet code area: Private Sub Worksheet_Change(ByVal Target As Range) Application.EnableEvents = False Cells(Target.Row, 1).Value = "C" Application.EnableEvents = True End Sub -- Gary''s Student - gsnu200738 "Picman" wrote: I would like to indicate with a specific value ("C") in the first cell of a row if any changes have been made in that row since the file was created. In other words if a value was input or changed in cell "M1" i would like cell "A1" to be populated with a "C". Can this be done? -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
indicate a change in a row
I must be missing something here because this did nothing.
"Dave Peterson" wrote: Right click on the worksheet tab that should have this behavior and select view code. Then paste this into the newly opened codewindow. Picman wrote: Could you walk me through the "worksheet code area". I'm not familier with this part of Excel. Also how can i change the coordinates of the destination cell to allow for column headings etc? "Gary''s Student" wrote: Put the following macro in the worksheet code area: Private Sub Worksheet_Change(ByVal Target As Range) Application.EnableEvents = False Cells(Target.Row, 1).Value = "C" Application.EnableEvents = True End Sub -- Gary''s Student - gsnu200738 "Picman" wrote: I would like to indicate with a specific value ("C") in the first cell of a row if any changes have been made in that row since the file was created. In other words if a value was input or changed in cell "M1" i would like cell "A1" to be populated with a "C". Can this be done? -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
indicate a change in a row
Macros have to be enabled.
Events can't be disabled. Put the code in the worksheet module. Save and close the workbook. reopen the workbook If you get prompted to allow macros, answer yes. Then change a cell outside of column A to see if it works. ==== If you don't get prompted, then post back with the version of excel you're using. Picman wrote: I must be missing something here because this did nothing. "Dave Peterson" wrote: Right click on the worksheet tab that should have this behavior and select view code. Then paste this into the newly opened codewindow. Picman wrote: Could you walk me through the "worksheet code area". I'm not familier with this part of Excel. Also how can i change the coordinates of the destination cell to allow for column headings etc? "Gary''s Student" wrote: Put the following macro in the worksheet code area: Private Sub Worksheet_Change(ByVal Target As Range) Application.EnableEvents = False Cells(Target.Row, 1).Value = "C" Application.EnableEvents = True End Sub -- Gary''s Student - gsnu200738 "Picman" wrote: I would like to indicate with a specific value ("C") in the first cell of a row if any changes have been made in that row since the file was created. In other words if a value was input or changed in cell "M1" i would like cell "A1" to be populated with a "C". Can this be done? -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change scaling % but font size didnt change porportionally, pls he | Excel Discussion (Misc queries) | |||
| Excel bar chart formatting of bars to change colors as data change | Excel Discussion (Misc queries) | |||
| Use date modified to change format & create filter to track change | Excel Worksheet Functions | |||
| change info in other cells when i change a number in a drop list? | Excel Discussion (Misc queries) | |||
| Change workbook sheet reference using cell A1 to change a vairable | Excel Worksheet Functions | |||
Hybrid Mode
