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

B

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
 
B

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.
 
D

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.
 
C

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
 
B

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.
 
B

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?
 
Top