Excel help

Closed
steve0_t - 23 Feb 2010 à 09:28
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 23 Feb 2010 à 09:36
Hello,

I want to make cell to display the date at the time a cell is populated by a name from a drop list.

E.g. cell i3 to display the current date when h3 has a been populated "noobie" from a droplist

if anyone knows how to do this, please can you help.

Thank you
Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
23 Feb 2010 à 09:36
You would have to use event function change of the sheet.

some thing like

Private Sub Worksheet_Change(ByVal Target As Range)

if (range("H3")<> "" then Range("I3") = date()
End Sub