Excel's textboxes don't support this kind of thing.

You can parse/validate the entry after you get it or maybe you could use a
calendar control to get the date.

Ron de Bruin shares calendar control instructions he
http://www.rondebruin.nl/calendar.htm

wrote:

Is it possible to have an input mask in a user form in excel? I want text
box for entering dates.

Ideally, I could have it show: "--/--/--"
And the number would fill in each black character.

Thanks

--

Dave Peterson