Cell change event in Visual Basic for Excel

[Matt27]

I am trying to write a bit of code in Visual Basic. I have a spreadsheet where cell F13 will be the User Name and cell N13 will be a date field to show the date they need their request completing. What I need to do in my code, is say when cell F13 is blank give a default date of 01/01/2010. When cell F13 has a name in it then leave cell N13 empty so the user can to enter a date. Is there an on change event I can use, or some other method to be able to do this?

 

[SkipVought]

Mat,

Please post in VBA Visual Basic for Applications (Microsoft) forum707

Skip,

_{[red]Be Advised![/red] The only distinction between a bird with one wing and a bird with two, is merely...
a difference of A Pinion!}