Thread: DateTimePicker
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
crazybass2 crazybass2 is offline
external usenet poster
 
Posts: 167
Default DateTimePicker

I want to add a datetimepicker into a form. I have found many articles about
using the datetimepicker class, but I cannot find anything in my version of
Excel (XP) or MS VB (v6.3). Is there some place I can download the addin
file so that my machine will have this capability.

What I want is...

A user (not necessarily on my machine) clicks a button. The button will
cause a date/time picker pop up. When the user selects a date and time this
date and time will be set in a variable.

As an alternative, I'd like some code that will ask for user input in
"m/dd/yy hh:mm:ss" format and then verify that it is a proper date/time.

Thanks in advance for the input.

Mike