I'm trying to find an elegant way of changing cells in a spreadsheet as a consequence of changing a specific cell. Because of formatting issues I'd like to do this using an Excel Event. Specifically I would like a macro to fire when I change the value of a particular cell based on a list choice through Data/Valadation/List. I thought that creating a subroutine using: "Private Sub Worksheet_Change(ByVal Target As Excel.Range)" would be a good idea but I can't figure out the syntax. Any thoughts on this?