one way:

Dim vResponse As Variant
Do
vResponse = Application.InputBox( _
Prompt:="Enter Date:", _
Title:="Date Entry", _
Default:=Format(Date, "mm/dd/yyyy"), _
Type:=2)
If vResponse = False Then Exit Sub 'User cancelled
Loop Until IsDate(vResponse)



In article ,
BeardT wrote:

I'd like to write a macro where it prompts me to enter a value for a cell
half way through without stopping. For example, I might like to include a
date once a set of data has been manipulated, after entering this, I'd like
the macro to continue running. Is there a way Excel can do this?