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
