Hi all,
So I'm rather new to VBA and am currently spending some time learning a bit about it and attempting to apply it to to some workbooks.
I've created a macro which displays a pop up where users enter a date, this date then gets pasted into a cell with feeds reports.
When I run this and type the date in as DD/MM/YY it comes out as MM/DD/YY. I've changed the formatting of the cell and ensures it says DD/MM/YY.
Sub Period_Selector()
Dim answer As Variant
answer = InputBox("Please type the month required:" & vbNewLine & "Format: DD/MM/YY", "Select Month", "Feb-16")
If answer <> "" Then
Worksheets(1).Range("B2").Value = answer
Else
'do nothing
End If
End Sub
Thanks in advance,
Sam
P.S. if you have any great learning resources/recommendations for VBA please share
Bookmarks