Forms in Excel - MaskEdBox control problem
Posted on 2003-03-07
I'm working on an user form in Excel 2000's Visual Basic Editor. The form has two fields to enter specific dates, and I want the fields to have a date mask so the data is entered in an specific date format (mm/dd/yy). If the data is not entered in that format, I want the macro to generate an error message.
I tried adding Maskedbox controls to the form for that purpose, but when I do I get the following error:
"The control could not be created because it is not properly licensed."
How do I solve this? If I can't use that type of control, why do I have it as an available choice? Is there another way to achieve the same results?
Thanks for any help!
PS - Please remember that I'm working with Excel, not Access.