View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dan dan is offline
external usenet poster
 
Posts: 866
Default Input Box default value as a date

1. I want my InputBox to have a default value of a
date,NOW but i keep getting a TYPE mismatch error. 2. I
would like the same as #1 but NOW +90 (days).
This is what I have:
Dim StartDate As Date
#1 StartDate = InputBox("Words", "Title", Now(),2)

#2 EndDate = InputBox("Words", "Title", Now()+90,2)