Masked Edit Control? (Date formats)
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")
Re: Masked Edit Control? (Date formats)
Hi
Why don't you use the date time picker control?
Will save you from lot of coding...
Re: Masked Edit Control? (Date formats)
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:confused: