VBA Code to change Cell value depending on Input value

[VBA_Joy]

Please help Guys, I need a vba formula that will change the cell value to the current date when I enter the value("x") or Value("X") in the cell. The current date must be populated in the cell where the x was inputed
Thanks, I am still new in VBA and Macros and I am learning everyday with this forum.Thanks

 

[Bilbo_Baggins_Esq]

There is a "SheetChange" event which might be used for this, however you would need to consider if you want to restrict to column(s) and/or rows that would be senstivie to this edit.

Also, to be clear, even if you have checks built in, to restrict the column and or row, some code will run on EVERY CHANGE.

http://msdn.microsoft.com/en-us/library/microsoft.office.tools.excel.workbook.sheetchange.aspx

 

[VBA_Joy]

Thanks a lot, It just did the wonders, Here is a short code that Did all the magic

Private Sub Worksheet_Change(ByVal Target As Range)

If UCase(Target.Value) = "X" Then
Target.Value = Now
End If
End Sub