DTpicker

[kj135]

I've created a user form in Excel 2003, I'm using DTpicker to select a date.
My question is how can I copy the DTP value into a cell on a spreadsheet?.

Thanks in advance

kj135

 

[Mike]

One way if you are going to put code into the forms module
Range("F1").Value = DTpicker1.Value
Range("F2").Value = DTpicker2.Value

Another way if your going to put code into a reg module

Range("F1").Value = form1.DTpicker1 .Value
Range("F2").Value = form1.DTpicker2.Value

 

[kj135]

Thanks worked great.

One way if you are going to put code into the forms module
Range("F1").Value = DTpicker1.Value
Range("F2").Value = DTpicker2.Value

Another way if your going to put code into a reg module

Range("F1").Value = form1.DTpicker1 .Value
Range("F2").Value = form1.DTpicker2.Value