VBA changes date format, pls help

[mrhonda]

Hi guy's,

I'm running into some trouble with my userform.

I have one sheet with dates in format dd/mm/yy (european)
These dates are used as input for a combobox in the userform.
The combobox shows the dates as they should be, no problems here.

After a date is selected, the value of the combobox is placed in a cell on my primairy sheet.
The format then is changed to the American style (mm/dd/yy). However the properties of the cell is still European. the date has changed.

For instance. 3-7-2011 = (#40609 =ok) is changed to 7-3-2011 = (#40727 =not ok)

Important for me is that the cell format must be a date, the correct date. Because formulas depend on this value, as a date.

Is there maybe a VBA code that copies the combobox value as a dd/mm/yy format?

Thanks a million

 

[GlennUK]

You say "the value of the combobox is placed in a cell on my primairy sheet" ... show the line of code that does that.

 

[RoryA]

You need to use CDate:

range("A1").value = cdate(combobox.value)

for example.

 

[mrhonda]

This was the simpel VBA line I used:
Range("F5") = DateBox.Value


Now I changed it to: Range("F5").Value = CDate(DateBox.Value)
And it works like a charm.

Thanks Rorya