rhythm
06-19-2012, 05:57 AM
I wrote this code to give a prompt to start a process but whenever I run the macro within the same instance of excel, it never prompts more than once. To remedy this I have to close out of excel entirely and re-run the macro -- is there a way around that? Thanks!
Private Function TimePrompt() As String
Static ans As String
If ans = vbNullString Then
ans = InputBox("Please specify the time period of this report:")
End If
TimePrompt = ans
End Function
Private Function TimePrompt() As String
Static ans As String
If ans = vbNullString Then
ans = InputBox("Please specify the time period of this report:")
End If
TimePrompt = ans
End Function