code an input field that asks for current date

I would like to create a macro that will ask for the current date and input
the value into the header of a weekly report. How do I do this?

Thanks in advance,
jag

jaggyone:

try,

Range("A1") = CDate(VBA.InputBox("Input current date", Default:=Date))

--
天行健，君�*�以自強不息
地勢坤，君�*�以厚德載物

http://www.vba.com.tw/plog/


"jaggyone" wrote:

> I would like to create a macro that will ask for the current date and input
> the value into the header of a weekly report. How do I do this?
>
> Thanks in advance,
> jag