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

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

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

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

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

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

Thanks.

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

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.

wrote:

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

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

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




wrote in message news:JNIuj.41184$yE1.6017@attbi_s21...
Wow, I don't see a "calendar control" as one of the option in the toolbox
though. Where do I find that option?

Thanks.

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

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.

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

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?

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

With office 2000, this is all I have:

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

:O/

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

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

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

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

wrote:

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?

--

Dave Peterson