|
-
Mar 25th, 2007, 07:19 AM
#1
Thread Starter
Hyperactive Member
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")
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|