Previous Topic Next Topic

Excel help

Closed
steve0_t - Feb 23, 2010 at 09:28 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 23, 2010 at 09:36 AM
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

1 reply

Answer 1 / 1
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
Feb 23, 2010 at 09:36 AM
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
0