Convert Integer to Date

[seasidematt]

Hi,

Is it possible to convert a integer number into a date format?

I have a problem wheer my dates being input into a vba form that are showing as the integer date.

Is there some code that would validate and convert this number to a date format i.e. DD/MM/YYYY

Any help would be most appreciated

Matt

 

[RoryA]

So it's not a userform at all, but a worksheet with some controls stuck on it? (yuck )

 

[seasidematt]

Yes it is sorry

 

[RoryA]

Are they from the Forms toolbar or the Control Toolbox?

 

[seasidematt]

Control Toolbox

 

[RoryA]

Oh dear.
Any chance of using an actual userform instead?

 

[seasidematt]

Unfortunately I'm to far gone to change now... I'm presenting this on Thursday for roll out across my organisation.. I think user forms are the way forward but that would have to be for version 2.0<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>

 

[RoryA]

The simplest fix I think would be to format the date cells as Text on the data sheet - that should flow through to the control.

 

[seasidematt]

Roy,

Thanks that was my contingency if i couldnt get it to work. Anyway thanks for your help..

I promise my next one will be a user form!

Matt