Input Mask in XL Userform??

[VulcanJedi]

Is there a way to implement an input mask in an XL Userform? I want ensure date format in textbox? Tranpkp

 

[RobBroekhuis]

You can do just about anything in the _change event handler for the textbox. Alternatively, you could look into the calendar/datepicker controls.
Rob

 

[VulcanJedi]

I got the calendar thing, but sometimes it is just easier to type in.... Tranpkp

 

[RobBroekhuis]

How do you want to configure the input mask? Just a check when the user is done, or hand-holding as the user is typing?
Rob

 

[VulcanJedi]

I guess the latter like in MS Access, but just a dream I suppose. I already wrote a ton of preventative code. Tranpkp

 

[RobBroekhuis]

It certainly can be done, with some effort. You just have to be very specific about the requirements, and implement rigorously. For example, it's easy to deal with new characters as they are typed, but you also need to correctly handle the user backspacing, or even selecting a portion of text in the middle of the textbox and replacing it with a keystroke.

Rob

 

[VulcanJedi]

I REFUSE to implement all that, ugh...isn't there a simple solution? Anybody? I feel bad I've exhausted this much of Rob's time already, and I refuse to do all that code for people to be lazy. So unless there's a much simpler solution, Calendar it is. Tranpkp

 

[RobBroekhuis]

The calendar control can be cumbersome, but I think the DTPicker control may be more what you're looking for (it's in Microsoft Common Controls). You can choose to just type your date, or pick from a calendar by hitting the dropdown arrow.
Rob