Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date error
I have the following sub which errors:
Sub Monthdate() Dim celldt As Date Dim TsMonth As Date TsMonth = InputBox("Enter month number for timesheet, such as (1) for Jan", "Timesheet Month...", 1) celldt = TsMonth & "/1/2005" Error on this line Range("S2").Value = celldt End Sub I want cell S2 to display the first date of the month specified in the input box. TIA Greg |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date Value Error | Excel Discussion (Misc queries) | |||
date error | New Users to Excel | |||
date error | Excel Discussion (Misc queries) | |||
Date Error - HELP! | Excel Discussion (Misc queries) | |||
Date Error | Excel Programming |