Excel - Control Toolbox - Text - Date Formatting

[rhb1]

Does anybody know how to validate a Text field, selected from the Control Toolbox within Excel, so that it displays dates in dd/mm/yyy format rather than the serial number ?

Thanks

RHB

[alonebfg]

you need to format the cell to date short date i think it is but dont quote me on that its been a while since i used exel in anger

[rhb1]

If only it was that simple. That wroke within any cell within the Worksheet.

I have created a text object,via the Control toolbox, which is linked to a specific cell via the LinkedCell property.

Even though the cell is in a date format, it shows the cerial number within the text object.

Wondered if anyone knows a way of formatting it within the LinkedCell property. Have tried Format(CellNo,"DD/MM/YY") but the property does not like it. I ams sure I could code it in the macro but though there must be an easier way.

RHB

[apeo]

Did a quick google and looks like you have to code it to be able to validate/format it.

[apeo]

Oh you could also use Microsoft Masked Edit Control instead of a TextBox Control.

[rhb1]

Now I am out of my depth.

Is that within .NET ?

Don't think its part of standard Exel ?



RHB1