Home |
Search |
Today's Posts |
#1
|
|||
|
|||
format combobox in userform to accept dates
I've designed a userform that requires dates to be selected from a list
of dates. When an item is selected it shows as the numeric version of the date in the userform. Is there any way to format the combobox so it presents in date format? |
#2
|
|||
|
|||
format combobox in userform to accept dates
I'm not sure if you can format the combobox to do that, but you can with the
list of dates. With the date in A1, in B1 try =TEXT(A1,"dd mmm yy") and use column B in the UserForm, Regards, Alan. "Brad" wrote in message oups.com... I've designed a userform that requires dates to be selected from a list of dates. When an item is selected it shows as the numeric version of the date in the userform. Is there any way to format the combobox so it presents in date format? |
#3
|
|||
|
|||
format combobox in userform to accept dates
Thank you Alan.
I think that will work. I'm using the dates in formulas so I'll have to add an additional step to vlookup in order to cross reference when I need to convert back to the dates for those calculations. Again thank you Brad |
#4
|
|||
|
|||
format combobox in userform to accept dates
Thank you Alan.
I think that will work. I'm using the dates in formulas so I'll have to add an additional step to vlookup in order to cross reference when I need to convert back to the dates for those calculations. Again thank you Brad |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I format dates accessed by a formula | Excel Discussion (Misc queries) | |||
Formating Dates for production schedule | Excel Discussion (Misc queries) | |||
due dates | New Users to Excel | |||
Date format collapses diagram | Excel Discussion (Misc queries) | |||
Any way to force European format dates in sheets? | New Users to Excel |