Is there a way to have fixed format in a userform?

[bob]

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]

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 here:
http://www.rondebruin.nl/calendar.htm

 

[bob]

Wow, I don't see a "calendar control" as one of the option in the toolbox
though. Where do I find that option?

Thanks.

 

[Dave Peterson]

It comes with Access (I think). If you didn't install Access, then you won't
have this control.

But Ron's site has an alternative.

 

[Conan Kelly]

bob,

Did you try right-clicking the toolbox > Additional Controls...

Scroll down the list. Not too far from the top is "Calendar Control 11.0".
If you keep looking throught the list, you might see a couple other
different calendar controls.

HTH,

Conan

 

[bob]

Ok, but I am putting together a userform EXCEL. I am using an old version
though. I think it's time to upgrade. I have '00.

 

[bob]

Hmm..... now I am wondering if I upgrade the basic which doesn't include
access. Will it just upgrade the others and leave me with access '00?

 

[bob]

With office 2000, this is all I have:

http://home.mchsi.com/~emails/tool.jpg

:O/

 

[bob]

Ahhhhh..... sorry. I did this and revealed 9.0. Thanks!

 

[Dave Peterson]

You still may want to use the free calendar control that Ron refers to.