I've got a date picker working on a spreadsheet using the MS date and time control picker 6.0. All is working well.

What I want to do now though is to concatenate some text with the date value from the control box and end up with a txt string that reads something like

'The date for this invoice is 16/03/07'. (Where the date comes from the control box).

I've tried refering to the date in the control box as 'DTPicker1', as that seems to be it's name, but that doesn't work.

Can anyone help in explaining how I can reference, and use, the contents of the date picker control box.