| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
InputBox a date
Excel 2002, WinXP
I want the user to respond to an InputBox with a date, like 1/1/05. However, subsequent checks of this date against another date fail because the Input date is a string. I know that I can force the Input 1/1/05 into a date with the DateSerial function. Is there a quicker, better way? The variable that gets the Input date is declared a Variant. Thanks for your help. Otto |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Date in InputBox for criteria in code | Excel Programming | |||
| Using InputBox to get desired date for a Query pulling data from Access into Excel | Excel Programming | |||
| Inputbox to enter date | Excel Programming | |||
| Inputbox as Date | Excel Programming | |||
| Date from InputBox | Excel Programming | |||
Threaded Mode
