View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Wes[_3_] Wes[_3_] is offline
external usenet poster
 
Posts: 5
Default Simple way to input dates

Just wondering if there is a simple way to have a user
input a date. I have been trying to make a user form
where a user will input a valid date. I made dropdown
lists to choose month day and year, but I don't want the
user to be given the choice to select an invalid date. In
otherwords I need to make sure that the number of days in
a month is correct.

I intend to further narrow down the choice of valid dates
to being only weekdays and not holidays, in case this
changes your opinion on what the best solution for me
would be.

Thanks in advance for any advice!