Thread: DTpicker
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
kj135 kj135 is offline
external usenet poster
 
Posts: 4
Default DTpicker

Thanks worked great.

"Mike" wrote:

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" wrote:

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