How to clear out this code?

[storemannequin]

I've written this prompt to get info from the user but after the macro runs, when I go to run another report with the macro, it doesn't prompt again and the old user inputted information remains. Only when I close the whole excel application and open a new instance does it work. Is there a way to clear the information?

Private Function TimePrompt() As String
    Static ans As String
    If ans = Empty Then
        ans = InputBox("Please specify the time period of this report:")
    End If
    TimePrompt = ans
End Function

 

[VoG]

Try

Private Function TimePrompt() As String
    Dim ans As String
    If ans = vbNullString Then
        ans = InputBox("Please specify the time period of this report:")
    End If
    TimePrompt = ans
End Function

 

[storemannequin]

hmmm..that constantly reprompts me for each time i reference the variable in the prompt -- is there a way to make it static for the entire execution length and then clear out? thanks