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
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 23 Feb 2010 à 09:36
Related:
- Excel help
- Excel mod apk for pc - Download - Spreadsheets
- Kernel for excel repair - Download - Backup and recovery
- Vat calculation excel - Guide
- Arrow keys not working in excel - Guide
- Transfer data from excel to excel - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
23 Feb 2010 à 09:36
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
some thing like
Private Sub Worksheet_Change(ByVal Target As Range)
if (range("H3")<> "" then Range("I3") = date()
End Sub