DTpicker

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Thanks worked great.

Mike said:
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
Click to expand...
 
Back
Top