Masked Edit Control? (Date formats)

[ggodwin]

Does Excel support the the Masked Edit Control?
I have been looking all over trying to find this control and having NO luck?
I know some visual basic programs support it but am wondering if Excel does?

Does anyone know if it is possible in excel?

I have a user form (FrmSKPISearch) that has two text boxes inside.(txt_Startdate, txt_EndDate) I would like to be able to put a default value into the boxes with the format of "mm/dd/yyyy".

The default values I am looking for is
txt_StartDate: 01/01/2007
txt_EndDate = 1 day minus what ever "todays" date is.

If this is not possible, I would like to a least force the user to input the dates in this format __/__/____ ("mm/dd/yyyy")

[Siddharth Rout]

Hi

Why don't you use the date time picker control?

Will save you from lot of coding...

[ggodwin]

I have looked into that but have yet to find a good example of how to do that? Do you have a good example? I seem to be running in cirlces on this issue