PC Review


Reply
 
 
=?Utf-8?B?a2oxMzU=?=
Guest
Posts: n/a
 
      1st Jun 2007
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

 
Reply With Quote
 
 
 
 
=?Utf-8?B?TWlrZQ==?=
Guest
Posts: n/a
 
      1st Jun 2007
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
>

 
Reply With Quote
 
=?Utf-8?B?a2oxMzU=?=
Guest
Posts: n/a
 
      1st Jun 2007
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
> >

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:38 PM.