Including prompts in macros
hi,
yes there is a way. assuming cell = A1
Private Sub inputdate()
Range("A1").value = inputbox("enter a date")
end sub
adjust A1 for the cell you want the date input to. you
didn't include enough info to write more of the macro.
Regards
Frank
-----Original Message-----
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?
.
|