Hi guys,
If it is not too much to ask can someone help me out with the below.
Basically I have this macro which every time it is run an input box will pop up and:
-if a 1 is inserted it will call a macro called January
-if a 2 is inserted it will call a macro called February
Sub Monthly_Report_viewer()
vervolg:
r = InputBox("Type the Month you would like to view" _
& Chr(13) & Chr(13) & "e.g:1 for January", "Monthly Report")
If r = 1 Then
Call January
Exit Sub
End If
If r = 2 Then
Call February
Exit Sub
End If
GoTo vervolg
End Sub
Now, the input box also has a 'Cancel' button. Would it be possible to amend the code so as to close the input box if someone clicks the 'Cancel' button?
Appreciate a lot your kind help!!
Thanks
Keibri
Bookmarks