View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Stone Frank Stone is offline
external usenet poster
 
Posts: 134
Default 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?
.