| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
code an input field that asks for current date
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I show the current month in a date field? | Excel Discussion (Misc queries) | |||
| Having input the current date in a cell I want to lock it | Excel Programming | |||
| Having input the current date in a cell I want to lock it | Excel Programming | |||
| Having input the current date in a cell I want to lock it | Excel Programming | |||
| CODE to select range based on User Input or Value of Input Field | Excel Programming | |||
Hybrid Mode
