Hi All
I have a userform with a listbox, one of the columns representing a date in dd/mm/yyyy format or at least that is the plan.
I have a date column in dd/mm/yyyy display format.
I need to display this in the listbox.
To do this I have an additional column and use the TEXT function to represent the date as text.
The original date column displays in the listbox as mm//dd/yyyy (incorrect) and the one using the TEXT function correctly in dd/mm/yyyy (correct) as I have specified.
BUT when I substitute the value in the column using the TEXT function with the value returned by the TEXT function, it turns the date into text but using the
mm/dd/yyyy format.
Does anybody know how I can get around this problem?
Thanks for any help.
I populate an array with values from a range and then populate the listbox using the List property.
To get around the date formatting issue, I use the TEXT function in the next column in the worksheet to turn the date into text. When I do this manually
the date is displayed correctly, dd/mm/yyyy, but when I automate this, apply the formula and then change the value to that returned by the formula, the date is formatted
to mm/dd/yyyy.
What is the most robust way around this problem?
I have a userform with a listbox, one of the columns representing a date in dd/mm/yyyy format or at least that is the plan.
I have a date column in dd/mm/yyyy display format.
I need to display this in the listbox.
To do this I have an additional column and use the TEXT function to represent the date as text.
The original date column displays in the listbox as mm//dd/yyyy (incorrect) and the one using the TEXT function correctly in dd/mm/yyyy (correct) as I have specified.
BUT when I substitute the value in the column using the TEXT function with the value returned by the TEXT function, it turns the date into text but using the
mm/dd/yyyy format.
Does anybody know how I can get around this problem?
Thanks for any help.
I populate an array with values from a range and then populate the listbox using the List property.
To get around the date formatting issue, I use the TEXT function in the next column in the worksheet to turn the date into text. When I do this manually
the date is displayed correctly, dd/mm/yyyy, but when I automate this, apply the formula and then change the value to that returned by the formula, the date is formatted
to mm/dd/yyyy.
What is the most robust way around this problem?