DTpicker

's Computer Specifications

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

's Computer Specifications

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
>

's Computer Specifications

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
> >

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
DTPicker Bug	=?Utf-8?B?U3RldmUyMw==?=	Microsoft Excel Programming	0	26th Jun 2007 11:36 AM
DTPicker	Syed Haider Ali	Microsoft Excel Programming	0	11th Jul 2006 08:38 PM
Dtpicker problem, any ideas why I can't set my dtpicker control to now()	Patrick Gibbons	Microsoft Access Forms	2	10th Feb 2004 08:34 PM
DTPicker	Steve	Microsoft Access Form Coding	1	23rd Dec 2003 04:46 PM
dtPicker	Tony	Microsoft Outlook Form Programming	0	12th Dec 2003 07:58 PM