View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Fuzzy31 Fuzzy31 is offline
external usenet poster
 
Posts: 5
Default date drop down box in vba

Hello,
I am new to vba for excel. Ive tried finding the solution in many books but
was unable.
I need to create date drop down box that will defualt to the current day,
but give the user the option to select another day up to at least 32 days
before the current day. I also need the selected day to appear in seveal
cells in the workbook. And if it is possible to show the day of week next to
the selected date.
Format mm/dd/yyyy

Thank for your Help

Jim