Userform (Combobox)

[TiaXL]

Hi All

Need a bit of help. I have a userform with 1 combobox on it and an OK button this is used to filter data based on a week ending date. When selecting the drop down list the dates display correctly as "DD/MM/YY" but when an option is selected it changes to an excel general format of "40175" any idea how I can make the form keep its formatting after the value is selected ?

 

[kpark91]

Hi, Tia.

When you have selected a date, is there any code executed?
If so, would it be possible for you to post it on here?

 

[RoryA]

Don't link the combobox to a range directly - populate it in code using the List property or AddItem.

 

[TiaXL]

Don't link the combobox to a range directly - populate it in code using the List property or AddItem.

Additem is no good I am listing week ending dates for the whole year, so too many. I am using Listfill

 

[RoryA]

You can use Additem in a loop, or create an array of the values, then use List. If you use the Rowsource then you will get the behaviour you describe. If you really want to use RowSource, then use the Change event to format the value as dd/mm/yyyy.