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

  • Thread starter Thread starter bob
  • Start date Start date
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
 
Wow, I don't see a "calendar control" as one of the option in the toolbox
though. Where do I find that option?

Thanks.
 
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.
 
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
 
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.
 
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?
 
Back
Top