| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is there a way to have fixed format in a userform?
|
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is there a way to have fixed format in a userform?
Ahhhhh..... sorry. I did this and revealed 9.0. Thanks!
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need A date Mask format for a Textbox on UserForm | Excel Discussion (Misc queries) | |||
| Currency Format on UserForm when opened! | Excel Discussion (Misc queries) | |||
| format userform text box | Excel Discussion (Misc queries) | |||
| Restrict date format for UserForm | Excel Discussion (Misc queries) | |||
| format combobox in userform to accept dates | Excel Worksheet Functions | |||
Hybrid Mode
