Previous Topic Next Topic

Excel help

Closed
steve0_t - Feb 23, 2010 at 09:28 AM
rizvisa1 Posts 4478 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
Related:

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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

Similar discussions

Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses