1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
| Sub inputDate()
'
' inputDate Macro
'
Application.ScreenUpdating = False
Sheets("EOL RESEARCH SUPITEM").Select
Dim date1 As Date
date1 = InputBox("Please inform the date of obervation (MM/AAAA).")
Sheets("STATUT EOL").Cells(2, 19) = date1
Dim i As Integer
For i = 1 To 17
Sheets("STATUT EOL").Select
Sheets("STATUT EOL").Cells(2, 19 - i).Value = DateAdd("m", -i, date1)
Sheets("STATUT EOL").Cells(2, 19 - i).Select
Selection.NumberFormat = "[$-409]mmm-yy;@"
Next
Sheets("EOL RESEARCH SUPITEM").Select
End Sub |
